Re: Running PL\SQL script from command line

|> I am new to Oracle, and I am using SQLPLUS. Is there anyway to execute a *.sql script from
|> the command line. Something like
|>
|> sqlplus -p filename.sql?

You can do it in two ways.

1. Put an '_at_' symbol before the name of the file. If you don't specify an extension, sql is assumed.

so to run a file test.sql you would say

SQL> _at_test or
SQL> _at_test.sql

Here you give the complete path of the file.

2. If you are embedding one file in another, say you want to execute test.sql which again would execute another file inside.sql, then you can specify

test.sql file {
 ....

_at__at_inside.sql
....

} end of file

Here the file inside.sql is assumed to have the same path as that of the file where it is invoked from.

Hope this helps ...

Regards,

Mahesh

-- 
Rachakonda Satya Mahesh	                   res: (913) 749-7540
University of Kansas, Lawrence             off: (913) 864-7737
mahesh_at_cecase.ukans.edu                    fax: (913) 864-7789