Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: passing variable from sqlplus to korn scripts ..
thx alex
-----Original Message-----
From: Afanassiev, Alex [mailto:Alex.Afanassiev_at_team.telstra.com]
Sent: Wednesday, September 13, 2000 6:45 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: passing variable from sqlplus to korn scripts ..
Hi Deepak
Maybe something like this will do for you ?
#!/bin/ksh # #JOBNAME="$0" #JOBNAME_SHORT=`basename $JOBNAME`
bdump varchar2(1000);
begin
select value into bdump from v\$parameter where name ='background_dump_dest'; dbms_output.put_line(bdump);
With regards
Alex Afanassiev
Oracle DBA, TOC OPS/Internet.Operations
Tel: (03) 8 661 20 61 Fax: (03) 9 650 36 74>
> -----Original Message-----
> From: Thapliyal, Deepak [SMTP:DThapliyal_at_ea.com]
> Sent: Thursday, September 14, 2000 10:02 AM
> To: Multiple recipients of list ORACLE-L
> Subject: passing variable from sqlplus to korn scripts ..
-- Author: Afanassiev, Alex INET: Alex.Afanassiev_at_team.telstra.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You mayReceived on Wed Sep 13 2000 - 20:49:19 CDT
![]() |
![]() |