Wednesday, June 29, 2016

Connecting to oracle database using MS-DOS cmdline



Connecting to oracle database using MS-DOS cmdline 



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\Drop_objs1.sql

-- We can add multiple sql scripts here

No comments:

Post a Comment