base_query
-
编辑 删除
oracle客户端NLS_LANG的设置
针对NLS_LANG简单写写常用环境配置:1. 简体中文windows cmdset NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK --sqlplus中文set NLS_LANG=American_America.ZHS16GBK --英文2. securecrt,Appearance-character encoding GB2312export LANG=en_US.GB2312export NLS_LANG='SIMPLIFIED CHINESE_CHINA.Z...
-
编辑 删除
How to get SCN ,TIMESTAMP ,CHECKPOINT
--current_scn(2 ways)select dbms_flashback.get_system_change_number ,timestamp_to_scn(sysdate) from dual;select a as scn_dec ,'0x'||lpad(ltrim(to_char(a,'xxxxxxxx')),8,'0') as scn_hex from (select dbms_flashback.get_system_change_number a from dual);--timestamp(current_timestamp,scn_to_t...
