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

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) 

Aucun commentaire:

Enregistrer un commentaire