Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: sqlplus within the unix shell

Re: sqlplus within the unix shell

From: Robert Sullivan <bsullivn_at_home.com>
Date: Sat, 08 Jan 2000 18:17:51 GMT
Message-ID: <38777FFB.5F2FE724@home.com>


vinduc_at_my-deja.com wrote:
> You can use the following syntax in your Shell Script :
> DATESYSDATE=`sqlplus -s scott/tiger <<EOF
> set heading off
> set pagesize 0
> set termout on
> set wrap on
> set feedback off
> set echo off
> set serveroutput on
> select sysdate from dual;
> exit
> EOF`
>
> Which put the date in the Unix Shell variable DATESYSDATE
Received on Sat Jan 08 2000 - 12:17:51 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US