How to call a sql file from shell script

I'm basically trying to call a sql script from a shell script. Below is my sql script plsql. Need Help: Shell script to call sql session with variables stored in. Need to write shell script for my. Hi Guys, I need to write a simple shell script which will generate a. Can somebody help me on this. Thanks in advance! Regards, LK 7 Replies. All rights reserved.

Enter user-name: t Call parallel sql scripts from shell and return status when both sql are done. Hi Experts: I have a shell script that's kicked off by cron.

Inside this shell script, I need to kick off two or more oracle sql scripts to process different groups of tables. And when both sql scripts are done, I will continue in the shell script to do other things like checking processing Here is idea about the code: my RedHat Commands. OpenSolaris Commands.

Linux Commands. Please explain the process with the help of a sample code and steps for me to understand How to connect to Oracle and how to place the output of the.

Its quite simple. I am using a simple example. You can adjust for yourself. For example you need to run:. This works perfectly fine and loads data in the file output. Instead of writing the sql query in the shell script itself? Did someone try this before?

Need some inputs to make this work. No Account? Sign up. By signing in, you agree to our Terms of Use and Privacy Policy. Already have an account? Sign in. By signing up, you agree to our Terms of Use and Privacy Policy. In the Target field, type powershell. The content you requested has been removed. Ask a question. Quick access. Search related threads. Remove From My Forums. Answered by:. Archived Forums. SQL Server Security. Sign in to vote.