Pass SQL in variable to SQLPlus instead of external file.

[Wrathchild]

It seems using an external file to house the SQL is SOP for working with Oracle from a shell script. I have examples of this, but I'm trying to go a different route.

I was wondering if the SQL could just be in a variable and then pass that variable to the sqlplus command instead of referencing an external file? I'm using a Korn shell.

Something like:
export SQL
SQL="SELECT blah blah blah"
sqlplus -L -S user/password@db @ $SQL

 

[feherke]

Hi

I can only suggest to read faq759-2221. Maybe it helps.

Feherke.

http://rootshell.be/~feherke/

 

[PHV]

Even in this forum ! faq822-2218

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[feherke]

Hi

Lol. Did not observed it.

Feherke.

http://rootshell.be/~feherke/

 

[Wrathchild]

yes, I read it prior to posting

 

[hoinz]

Hi,

imho your answer is in the FAQ already mentioned.
Have a look at the use of Unix "|" symbol, e.g. in the very first example.

Details are left as an exercise to the reader ...

 

[Wrathchild]

thanks guys, I just skipped over the "print" example because I was looking for something that began with "sqlplus..." - the print example worked fine

 

[Wrathchild]

oh, and if anybody wants the final syntax I used:

export SQL
SQL="SELECT blah blah blah"
print $SQL | sqlplus -s user/password@db