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
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