I've been noticing that there a select few whose
messages constantly appear on this list (such as
yours, Deepak Thapliyal, and including Joe and Jared),
but I don't see mine soon. There's a lot of delay
before I finally get to see my posting. Why isn't this
delay the same for all ? Anyone ?
- Deepak Sharma
- "Thapliyal, Deepak" <DThapliyal_at_ea.com> wrote:
> thx to all who replied
>
> -----Original Message-----
> Sent: Wednesday, September 13, 2000 8:31 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi
> For ex:
>
> sqlplus -s user/pw > <spool file name> <<!EOF
> set head off feed off pagesize 0 pause off
> select value from v\$parameter where name
> ='background_dump_dest';
> exit;
> !EOF
> temp1=`cat <spool file name> | head -1` #if the
> sql returns one line
> output no need use head -1 in this statement
>
>
> Thanks & Regards
> ----------------------------
> Ram
> Tel:4236953
>
>
> ---------------------------------------- Message
> History
> ----------------------------------------
>
>
>
> Please respond to ORACLE-L_at_fatcity.com
>
> To: ORACLE-L_at_fatcity.com
> cc:
>
>
>
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L"
> <ORACLE-L_at_fatcity.com>
> Sent: Wednesday, September 13, 2000 4:01 PM
>
>
> > Hi guys
> >
> > goin thru a brain freeze here .. ur help
> appreciated in advance
> > here is the deal ...
> >
> > #!/bin/ksh
> > #
> > ..
> > .. ksh code
> > .. ksh code
> > .. ksh code
> > ..
> >
> > $ORACLE_HOME/bin/sqlplus -s / <<__EOF1
> > declare
> > bdump varchar2(1000);
> > begin
> > select value
> > into bdump
> > from v$parameter
> > where name ='background_dump_dest';
> > end;
> > /
> > exit
> > __EOF1
> >
> > ** how to accesss bdump variable value from
> sql*plas here in shell script
> > ??**************
> >
> > .. ksh code
> > .. ksh code
> > ..
> >
> >
> > Thx
> > deepAk
> > --
> > Author: Thapliyal, Deepak
> > INET: DThapliyal_at_ea.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 may
> > also send the HELP command for other information
> (like subscribing).
> >
>
> --
> Author: Mandar Ghosalkar
> INET: mghosalkar_at_staff.eindia.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 may
> also send the HELP command for other information
> (like subscribing).
>
>
>
>
> --
> Author:
> INET: ramakrishna.gv_at_db.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 may
> also send the HELP command for other information
> (like subscribing).
> --
> Author: Thapliyal, Deepak
> INET: DThapliyal_at_ea.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 may
> also send the HELP command for other information
> (like subscribing).
Received on Thu Sep 14 2000 - 16:30:09 CDT