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