Script:List NLS Parameters and Timezone

以下脚本用以列出Database-instance-session的NLS参数和所在时区:

REM List NLS Parameters

set linesize 90 pagesize 1400
col Parameter for a40
col Value     for a40

SELECT Parameter, Value FROM NLS_DATABASE_PARAMETERS
/

SELECT Parameter, Value FROM NLS_INSTANCE_PARAMETERS
/

SELECT Parameter, Value FROM NLS_SESSION_PARAMETERS  ORDER BY 1
/

select dbtimezone from dual
/

select sessiontimezone from dual
/

关注dbDao.com的新浪微博

扫码关注dbDao.com 微信公众号:

Speak Your Mind

TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569