ALL_PARAMETERS

CREATE VIEW ALL_PARAMETERS

AS

     SELECT I.KSPPINM NAME,

            I.KSPPDESC DESCRIPTION,

            CV.KSPPSTVL VALUE,

            CV.KSPPSTDF ISDEFAULT,

            DECODE (BITAND (CV.KSPPSTVF, 7),

                    1, 'MODIFIED',

                    4, 'SYSTEM_MOD',

                    'FALSE')

               ISMODIFIED,

            DECODE (BITAND (CV.KSPPSTVF, 2), 2, 'TRUE', 'FALSE') ISADJUSTED

       FROM SYS.X$KSPPI I, SYS.X$KSPPCV CV

      WHERE     I.INST_ID = USERENV ('INSTANCE')

            AND CV.INST_ID = USERENV ('INSTANCE')

            AND I.INDX = CV.INDX

            AND I.KSPPINM LIKE '/_%' ESCAPE '/'

   ORDER BY REPLACE (I.KSPPINM, '_', '');

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15489979/viewspace-745877/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/15489979/viewspace-745877/