rajivgupta780184

 Profile Answers by rajivgupta780184 Questions by rajivgupta780184

• Apr 13th, 2009

 

@[source drive]/filename.sql;

@c:/sql_script.sql

prasadreddi

 Profile Answers by prasadreddi 

• Mar 17th, 2010

 

@<path>filename.sql

give the path where the file is located extactly.

Ex :- Let us say our file is located at c:tempabc.sql

SQL> @"c:tempabc.sql"

It is better practice to use double quotes why bcoz if any foder name having any space that it will trouhg error.

If you are working in Unix box

SQL>@'/u01/temp/abc.sql" Here file is case sensitive.

dj_dj_dj

 Profile Answers by dj_dj_dj 

• Mar 18th, 2010

 

You can Call SQL Script by using @ and then giving path of the source file
For ex: @c:/sqlscript.txt;

Regards
Dharmendra Jaiswal