Oracle学习笔记

1、创建一张和A表结构一样但不带数据的表B

   create table B as select * from A where 1=0;

 

2、获取系统当前scn

   select dbms_flashback.get_system_change_number scn from dual;

 

3、获取隐含参数语句：

   SELECT x.ksppinm NAME, y.ksppstvl VALUE, x.ksppdesc describ
    FROM SYS.x$ksppi x, SYS.x$ksppcv y
   WHERE x.inst_id = USERENV ('Instance')
    AND y.inst_id = USERENV ('Instance')
    AND x.indx = y.indx
    AND x.ksppinm LIKE '%&par%'
   /