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%'
/
阅读(1577) | 评论(1) | 转发(0) |