select
to_char(to_date('27-abr-1985')) from dual

select
to_char(to_date('27/04/1985','dd-mm-yyyy'), 'DAY') from dual
select
'***'||to_char(sysdate-2, 'DAY')||'***' from dual
select
a,b into create
table tz (x int, y varchar(5));
insert
into tz
select
rownum, trunc(dbms_random.value(1,99999))
from
dual
connect
by rownum >=20;
select
* from tz
select
INSTR('palelepidedo','l',1,1) from dual
select
to_char(ADD_MONTHS(sysdate,-1),'day') from dual