PLSQL设置环境变量显示时间格式

set ORACLE_HOME=D:\ETL\tools\oracle12.2x32
set PATH=%PATH%;D:\ETL\tools\oracle12.2x32;

set NLS_LANG=AMERICAN_AMERICA.AL32UTF8
set NLS_DATE_FORMAT=YYYY-MM-DD
SET NLS_TIME_FORMAT=HH24:MI:SS
set NLS_TIMESTAMP_FORMAT=YYYY-MM-DD HH24:MI:SS.FF6
SET NLS_TIME_TZ_FORMAT=HH24:MI:SS.FF
SET NLS_TIMESTAMP_TZ_FORMAT=YYYY-MM-DD HH24:MI:SS.FF6

cd “D:\ETL\tools\others\PLSQL Developer”
rem start ./plsqldev.exe

plsqldev.exe