Sv: sqlplus & unix

From: Allan Saadbye <isl34485_at_image.dk>
Date: Fri, 9 Jul 1999 18:55:51 +0200
Message-ID: <EUph3.1800$K4.36156@news020.image.dk>

Hello Sarah

In unix you simply define a variable by stating Name='Sarah' or nxweek=`date '+%W'`+1
The next step in sqlplus is to :
select * from A_table
where name=$name
and em_of_the_week=$nxweek;

With regards Allan

Sarah Officer <officers_at_aries.tucson.saic.com> skrev i en nyhedsmeddelelse:3784F21E.908E6199_at_aries.tucson.saic.com...
> Is it possible to access a unix environment variable from sqlplus?
>
> Thanks,
>
> Sarah Officer
> officers_at_aries.tucson.saic.com
Received on Fri Jul 09 1999 - 11:55:51 CDT