Shel Script

Hello All,

Just had a question, as to how could we write a shell script in UNIX, if I wanted to execute SQL commands by simply running them within the shell script? (It could be any shell, c, korn,...etc..) I tried using the script with "sqlplus/ but it just gets stuck at the sqlplus prompt and waits for me to input some SQL commands....I think I must be missing something....any idea...?

Please let me know..

Thanks in advance.

--
--Rishi

## Never let your sense of morals prevent you from doing what is right. ##

• Salvor Hardin, "Foundation".