Queries :
SELECT AO.OWNER, AO.OBJECT_NAME, AO.OBJECT_TYPEFROM ALL_OBJECTS AO, OSRW
WHERE AO.OBJECT_NAME = OSRW.KEYWORD
AND AO.OWNER NOT IN ('SYS', 'PUBLIC', 'SYSMAN', 'XDB', 'CTXSYS', 'SYSTEM',
'WMSYS', 'OWBSYS', 'ORDSYS', 'ORDDATA', 'OUTLN',
'OLAPSYS', 'MDSYS', 'APEX_030200')
ORDER BY 1, 2;
SELECT ATC.OWNER, ATC.TABLE_NAME, ATC.COLUMN_NAME
FROM ALL_TAB_COLUMNS ATC, V$RESERVED_WORDS OSRW
WHERE ATC.COLUMN_NAME = OSRW.KEYWORD
AND ATC.OWNER NOT IN ('SYS', 'PUBLIC', 'SYSMAN', 'XDB', 'CTXSYS',
'SYSTEM', 'WMSYS', 'OWBSYS', 'ORDSYS', 'ORDDA
TA', 'OUTLN', 'OLAPSYS', 'MDSYS', 'APEX_030200')
ORDER BY 1, 2;
Aucun commentaire:
Enregistrer un commentaire