Re: How to read Environment variables in SQL

: I need to read the (Unix) shell variables with in SQL without passing them as
: parameters to the SQL script. i.e. NOT LIKE sqlplus user/pwd @script.sql $par1

Use the bourne shell to expand the variables:-

• snip -- #!/bin/sh

sqlplus -s / <<!
select '$LOGNAME' from dual;
exit
!
-- snip --

IAP

--
In an attempt to reduce junk email I use an invalid 'From' address.
My correct email address can be determined by replacing 'not.valid' with with
'value.net'