How to execute a local. SQL script file under Oracle

Analysis:

We usually in the development process will encounter a lot of program modification or bulk modification of data when the script will choose the form of the file is executed by the command, then how to execute SQL script file with Plsql or Sqlplus?

Description

If we now put a create.sql script file that we need to execute under the C-drive letter, if we use Sqlplus to execute this script file:

1. Go to the Run Command window.

2, Login Sqlplus

Connect Username/[email protected];

3. After the database connection is successful, execute the script file

@ ' c:\create.sql '; or @@c:\create.sql;

If you use the Plsql tool, create a new command window directly and execute the following code directly:

@ ' c:\create.sql '; or @@c:\create.sql;

　　

How to execute a local. SQL script file under Oracle