select lower('Servere de Date'),upper('servere de date'),initcap('servere de date')  from dual;

select sysdate, to_char(sysdate,'YEAR'), to_char(sysdate,'dd.mm.yyyy') ,to_char(sysdate,'dd.mm.yyyy hh24:mi:ss') from dual;

select to_date('2015/02/24', 'yyyy/mm/dd'), to_date('022415', 'MMDDYY'), to_date('20150224', 'yyyymmdd') from dual;

select lpad('Oracle', 20, 'ab ') from dual;

select sysdate-to_date('03-06-1987','mm-dd-yyyy') from dual;

select sysdate-to_date('03-06-1987','mm-dd-yyyy'), months_between(sysdate,to_date('03-06-1987','mm-dd-yyyy')), next_day(sysdate,'sunday'), last_day(to_date(sysdate, 'dd/mm/yyyy')),last_day(to_date(sysdate, 'dd/mm/yyyy'))+1 from dual;

select user, uid from dual;