Collected posts: Oracle, SQL, PL/SQL, Performance, Security...(More than 300 blogs)

jeudi 15 mai 2014

Oracle Reserved words check use












Queries :

SELECT AO.OWNER, AO.OBJECT_NAME, AO.OBJECT_TYPE
  FROM 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;

mercredi 14 mai 2014

Script: Oracle hidden parameters




SELECT ksppinm  AS NAME,
       ksppity  AS TYPE,
       ksppstvl AS VALUE,
       ksppstdf AS ISDEFAULT
  FROM x$ksppi x
 INNER JOIN x$ksppcv y ON (x.indx = y.indx)