Re: Newbie question: sqlplus command line

Assuming you're using Windows NT (it's similar for Win95), from a batch file enter the line

'C:\orant\bin\plus33w.exe username/password_at_database @script.sql'

where C:\orant\bin\ is your Oracle home, Plus33w.exe is the sql*plus executable, username/password_at_database is your connect string, and script.sql is your script. Unless the script is in the c:\orant\bin folder, or the folder that the batch file is executed from, you will need to specify the path

Hope this helps

Mark Rittman
Toyota Motor Finance
mrittman_at_tmf-europe.com

On 8 Apr 1999 15:48:18 GMT, "RABK" <rkarl_at_consultec-inc.com> wrote:

>What syntax is neccessary to run the sqlplus from a shell in order to
>automate the process?
>
>- Piping on User password and host
>
>- Piping on script file?
>
>Thanx,
>
>
Received on Fri Apr 09 1999 - 14:18:38 CEST