2009-06-25から1日間の記事一覧
例:削除文を検索SELECT * FROM V$SQLTEXT WHERE SQL_TEXT LIKE '%DELETE%' OR SQL_TEXT LIKE '%delete%' OR SQL_TEXT LIKE '%TRUNCATE%' OR SQL_TEXT LIKE '%truncate%' order by sql_text; select * from v$sqlarea where SQL_TEXT LIKE 'delete%';
例:削除文を検索SELECT * FROM V$SQLTEXT WHERE SQL_TEXT LIKE '%DELETE%' OR SQL_TEXT LIKE '%delete%' OR SQL_TEXT LIKE '%TRUNCATE%' OR SQL_TEXT LIKE '%truncate%' order by sql_text; select * from v$sqlarea where SQL_TEXT LIKE 'delete%';