Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: sqlplus within the unix shell
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
![]() |
![]() |