Re: sqlplus within the unix shell

From: Robert Sullivan <bsullivn_at_home.com>
Date: 2000/01/08
Message-ID: <38777FFB.5F2FE724_at_home.com>#1/1


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 - 00:00:00 CET

Original text of this message