ORACLE EXTRA

Find out Inverted Commas by instr function:
================================

select instr(name,'''',1) from test;

Insert Single Qoute Data:
================================

insert into test
values('alami''n');


show parameter undo;

select * from alamin as of timestamp to_timestamp('02-02-2016 10:10','dd-mm-yy hh24:mi')

alter table alamin enable row movement;

 flashback table alamin to timestamp to_timestamp('02-02-2016 10:10','dd-mm-yy hh24:mi')

SET SQLPROMPT "&_user@&_connect_identifier(&database_name) >"

SET SQLPROMPT "alamin >"; 

explain plan for
select * from employees where department_id='50'; 

select * from table (dbms_xplan.display()); 

Alter system set "_system_trig_enabled"=FALSE