Search table
Tuesday, 18 August, 2009
Leave a comment
SELECT *
FROM user_all_tables
WHERE TABLE_NAME LIKE UPPER('%ISSCR%')
AND TABLE_NAME NOT IN (SELECT TABLE_NAME
FROM user_all_tables
WHERE TABLE_NAME LIKE '%$%'
OR TABLE_NAME LIKE '%REP%');

Recent Comments