Oracle all_parameters view 創(chuàng)建sql

Oracle all_parameters view 創(chuàng)建sql 

/* Formatted on 2011/07/28 17:06:07 (QP5 v5.114.809.3010) */

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, '_', '');

--通過這個視圖可以查看隱含的參數(shù)

服務(wù)器租用/服務(wù)器托管中國五強(qiáng)！虛擬主機(jī)域名注冊頂級提供商！15年品質(zhì)保障！--億恩科技[ENKJ.COM]