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 /
posted on 2009-06-17 00:54 Oracle和MySQL 阅读(168) 评论(0) 编辑 收藏 举报