--single line method
select ascii('A') Big_A from dual;
select chr(65) A, chr(122) z, chr(223) ch3 from dual;
select concat('sigo','way') from dual;
select initcap('sigoway') from dual;
select instr('ababab','a',-1,2), instr('ababab','a',1,3) from dual;
select instrb('ababab','a',1,3) from dual;
select length('sigoway') from dual;
select lengthb('sigoway') from dual;
select upper('sigoway') , lower('SIGOWAY') from dual;
select lpad('Sigoway',10,'0'), lpad('Sigoway',5,'0') , rpad('Sigoway',10,'0'), rpad('Sigoway',5,'0') from dual;
select ltrim('Sigoway','Sigo'), rtrim('Sigoway','way') from dual;
select replace('Sigoway','go','og') from dual;
select substr('sigoway',3,2), substr('sigoway',3) from dual;
select soundex('hello') from dual;
select translate('Sigoway','og','ab') , translate('Sigoway','go','ab') from dual;
select trim(' sigoway ') from dual;
select abs(-1) from dual;
select acos(0.5), acos(1), acos(-1) from dual;
select cos(0.5), cos(1), cos(-1) from dual;
select asin(0.5), asin(1), asin(-1) from dual;
select sin(0.5), sin(1), sin(-1) from dual;
select ceil(-1) from dual;
select trunc(10.12345,4) ,round(10.12345,4) from dual;
select to_char(round(sysdate), ' yyyy-mm-dd hh24:mi:ss')
,to_char(trunc(sysdate), 'yyyy-mm-dd hh24:mi:ss')
from dual;
select to_char(Round (sysdate), ' Q ' ) Rnd_Q
,to_char(Round (sysdate), ' Month ' ) Rnd_Month
,to_char(Round (sysdate), ' WW ' ) Rnd_Week
,to_char(Round (sysdate), ' W ' ) Rnd_Week_again
,to_char(Round (sysdate), ' DDD ' ) Rnd_day
,to_char(Round (sysdate), ' DD ' ) Rnd
