for /F "tokens=2-4 delims=/ " %%i in ('date /t') do set currentdate=%%k-%%i-%%j for /F "tokens=1-3 delims=: " %%i in ('time /t') do set currenttime=%%i-%%j-%%k SET NLS_LANG=AMERICAN_AMERICA.TH8TISASCII rem SET SET NLS_LANG=THAI_THAILAND.TH8TISASCII rem SET NLS_LANG=AMERICAN_AMERICA.UTF8 SET ORA_ADM_USR=%1 SET ORA_ADM_PWD=%2 SET ORA_TARGET_DBSTR=%3 SET ORA_BUILD_KILL_SESSION_SQL_FILE=Alter_Oracle_Kill_Sessions_user_w3w.sql SET ORA_BUILD_KILL_SQL_FILE=kill.sql echo quit|sqlplus -s %ORA_ADM_USR%/%ORA_ADM_PWD%@%ORA_TARGET_DBSTR% as sysdba @%ORA_BUILD_KILL_SESSION_SQL_FILE%>%ORA_BUILD_KILL_SQL_FILE% echo quit|sqlplus -s %ORA_ADM_USR%/%ORA_ADM_PWD%@%ORA_TARGET_DBSTR% as sysdba @%ORA_BUILD_KILL_SQL_FILE%>results.log