Oracle: Execute a SQL script file in SQLPlus (Step By Step)

We can execute a SQL script file in SQLPlus. For consistency, use the .sql extension for the script file name.

A SQL script file is executed with a START or @ command.

Below are very easy step to execute a script.

1)      Step --Firstly we create file with .sql extension.

              For example

              vi  my_scripts\my_sql_script.sql

       2)  Step – Now logging in oracle

                  Sqlplus “/as sysdba”

             3) Step –Now executed scripts

            SQL> @ my_scripts\my_sql_script.sql

                      Or

          SQL> START   my_scripts\my_sql_script.sql