Oracle学习笔记
时间：2010-10-17 来源：dxwwp
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%'
/
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%'
/
相关阅读 更多 +
