ORACLE之常用FAQ V1.0一(构架体系)

,decode(isdefault, 'TRUE','Y','N') as "Default"

,decode(ISEM,'TRUE','Y','N') as SesMod

,decode(ISYM,'IMMEDIATE', 'I',

'DEFERRED', 'D',

'FALSE', 'N') as SysMod

,decode(IMOD,'MODIFIED','U',

'SYS_MODIFIED','S','N') as Modified

,decode(IADJ,'TRUE','Y','N') as Adjusted

,description

FROM ( --GV$SYSTEM_PARAMETER

SELECT x.inst_id as instance

,x.indx+1

,ksppinm as NAME

,ksppity

,ksppstvl as VALUE

,ksppstdf as isdefault

,decode(bitand(ksppi***/256,1),1,'TRUE','FALSE') as ISEM

,decode(bitand(ksppi***/65536,3),

1,'IMMEDIATE',2,'DEFERRED','FALSE') as ISYM

,decode(bitand(ksppstvf,7),1,'MODIFIED','FALSE') as IMOD

,decode(bitand(ksppstvf,2),2,'TRUE','FALSE') as IADJ

,ksppdesc as DESCRIPTION

FROM x$ksppi x

,x$ksppsv y

WHERE x.indx = y.indx

AND substr(ksppinm,1,1) = '_'

AND x.inst_id = USERENV('Instance')

)

ORDER BY NAME　　

[Q]怎么样查看数据库字符集　　

[A]数据库服务器字符集select * from nls_database_parameters，　　

其来源于props$，是表示数据库的字符集。