17,086
社区成员
发帖
与我相关
我的任务
分享
select t.sql_text into v_sql from v$sqlarea t, v$session s
where t.sql_id = s.sql_id
and upper(t.sql_text) like 'DELETE%'||v_table_name||'%'
and s.audid = userenv('SESSIONID');
delelte from tablename where id=v_id;