Re: sqlplus & unix

Does the UNIX variable need to be exported in order to be used in an Oracle SQL query?

I am new to UNIX and Oracle and need to modify some shell scripts that I have inherited.

Thanks in Advance!!!!

Iancrozier wrote:
>
> You can run sqlplus inside a unix shell e.g.
> #!/bin/sh
> variable=3
> export variable
> sqlplus -s username/password_at_instance << EOSQL
> select * from table
> where column = $variable
> /
> EOSQL

       The contents of this message express only the sender's opinion.
       This message does not necessarily reflect the policy or views of
       my employer, Merck & Co., Inc.  All responsibility for the statements
       made in this Usenet posting resides solely and completely with the
       sender.