Re: UNIX-Oracle script interface help

From: Lee Sang Ryung <srlee_at_shinsegi.com>
Date: 1998/12/09
Message-ID: <366E0894.286F@shinsegi.com>#1/1

I can't know excatly what you want.

If you just want to display TEST word, I think you change a little as below:

 #!/bin/ksh

 LOGNAME=testid
 PASSWORD=testpw
 SPOOL_FILE=./test.log

 sqlplus -s $LOGNAME/$PASSWORD <<!
 spool $SPOOL_FILE
 set heading off
 set linesize 300

 select 'E1', a.sls_org_cd, a.dist_chnl_cd,

        a.doc_crncy_cd,       a.cust_grp_cd, a.matl_cd,
        b.matl_nm

 from table_a a, table_b b
 where a.matl_id = b.matl_id;

 spool off
 !echo "TEST"

S.R.LEE Received on Wed Dec 09 1998 - 00:00:00 CST