Notes
Notes - notes.io |
select sys_date or current_date from dual;
select add_month (date,number_month) form dual;
select date between (date) as result from dual;
select months_between(date1,date2) as result from dual;
select extract (day from date) as day from dual;
select extract(month from date) as month from dual;
select extract(year from date) as year from dual;
select last_day(date) as result from dual;
select next_day(date,weekday) as result from dual;
To add 2 strings ("CONCAT"):- select concat ('string1','string2') as sample from dual;
Or we use "||" to concat string:- select 'Hello'||'World' as sample from dual;
To capitalise 1st letter in each word:- select initcap ('welcome you all') as sample from dual;
To find length of string:- select length('Hello World') as length from dual;
To remove unwanted character:- select LTRIM or RTRIM ('Hello World') as result from dual;
select LPAD or RPAD('string',padded_length,'str_to_add') as result from dual;
To convert all letter to uppes and lower case:- select lower or upper('Hello World') as result from dual;
To find location of sub string in a string:-select INSTR('Welcome','e') as result from dual;
|
|
Notes.io is a web-based application for taking notes. You can take your notes and share with others people. If you like taking long notes, notes.io is designed for you. To date, over 8,000,000,000 notes created and continuing...
With notes.io;
- * You can take a note from anywhere and any device with internet connection.
- * You can share the notes in social platforms (YouTube, Facebook, Twitter, instagram etc.).
- * You can quickly share your contents without website, blog and e-mail.
- * You don't need to create any Account to share a note. As you wish you can use quick, easy and best shortened notes with sms, websites, e-mail, or messaging services (WhatsApp, iMessage, Telegram, Signal).
- * Notes.io has fabulous infrastructure design for a short link and allows you to share the note as an easy and understandable link.
Fast: Notes.io is built for speed and performance. You can take a notes quickly and browse your archive.
Easy: Notes.io doesn’t require installation. Just write and share note!
Short: Notes.io’s url just 8 character. You’ll get shorten link of your note when you want to share. (Ex: notes.io/q )
Free: Notes.io works for 12 years and has been free since the day it was started.
You immediately create your first note and start sharing with the ones you wish. If you want to contact us, you can use the following communication channels;
Email: [email protected]
Twitter: http://twitter.com/notesio
Instagram: http://instagram.com/notes.io
Facebook: http://facebook.com/notesio
Regards;
Notes.io Team
