Showing posts with label sql. Show all posts
Showing posts with label sql. Show all posts

Tuesday, February 5, 2013

Execute Oracle script file in SqlPlus

Execute Oracle script file in SqlPlus.


If ur Oracle sqlplus is located in c:\oraclexe\app\oracle\product\11.2.0\server\bin>


go to c:\oraclexe\app\oracle\product\11.2.0\server\bin> type sqlplus
enter username and password.


If your .sql script is located in C:\oraclexe\app\oracle\product\11.2.0\server\rdbms\admin

from sqlplus type

SQL>@../rdbms/admin/scott.sql


if user is in in same directory as script directory


type SQL>@scriptname.sql



Tags: execute .sql in sqlplus, executing .sql in sql plus,execute an sql script in sqlplus.