SELECT a.First_Load_Time,
a.Sql_Text,
s.Sid,
s.Serial#,
s.Program --,
,
a.*
FROM V$sqlarea a, V$session s
WHERE s.Sql_Address(+)= a.Address
AND Upper(a.Sql_Text) LIKE '%DELETE FROM% ZJJGXXB%';
<1>判断字段值是否是纯数字 select * from table where trim(translate(column,’0123456789’,’ ‘)) is NULL;