oracle 设置字段为空
update person set address=null
oracle 查看脚本跟踪记录
alter session set sql_trace=true ;
select * from v$sqlarea where parsing_schema_name= 'GREENTEMP3' and last_load_time>sysdate -1/ 24 order by last_load_time desc;
select a.SQL_ID, a.ADDRESS,a.HASH_VALUE,a.PARSING_SCHEMA_NAME,a.EXECUTIONS,b.piece,b.sql_text,a.FIRST_LOAD_TIME,a.LAST_ACTIVE_TIME,a.MODULE ,a. PARSING_SCHEMA_NAME
from v$sqlarea a,v$sqltext b
where a.ADDRESS=b.ADDRESS
and a.HASH_VALUE=b.HASH_VALUE
and a.sql_text like '%PM_INSTRUMENT_V%'
and PARSING_SCHEMA_NAME like '%SMES30%'
order by a.ADDRESS,a.HASH_VALUE,b.PIECE asc;
oracle 获取变量值
update person set address=null
oracle 查看脚本跟踪记录
alter session set sql_trace=true ;
select * from v$sqlarea where parsing_schema_name= 'GREENTEMP3' and last_load_time>sysdate -1/ 24 order by last_load_time desc;
select a.SQL_ID, a.ADDRESS,a.HASH_VALUE,a.PARSING_SCHEMA_NAME,a.EXECUTIONS,b.piece,b.sql_text,a.FIRST_LOAD_TIME,a.LAST_ACTIVE_TIME,a.MODULE ,a. PARSING_SCHEMA_NAME
from v$sqlarea a,v$sqltext b
where a.ADDRESS=b.ADDRESS
and a.HASH_VALUE=b.HASH_VALUE
and a.sql_text like '%PM_INSTRUMENT_V%'
and PARSING_SCHEMA_NAME like '%SMES30%'
order by a.ADDRESS,a.HASH_VALUE,b.PIECE asc;
oracle 获取变量值