run sql from windows cmd prompt CLI
Method 1: set ORACLE_HOME=D:\app\oracle\product\11.2.0\db_1 set ORACLE_SID=ORCL sqlplus -s "USERNAME/PASSWORD" @C:\Shell\Drop_objs.sql sqlplus -s "USERNAME/PASSWORD" @C:\Shell\Change_pass.sql Method 2: set ORACLE_HOME=D:\app\oracle\product\11.2.0\db_1 set ORACLE_SID=ORCL (ECHO select username from dba_users where username in ('SCOTT'); ECHO exit;) | sqlplus -s "USER/PASS" > C:\Shell\test_out.txt