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.
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.
No comments:
Post a Comment