Shell Programming and Scripting

Create table X as
select doc_code, doc_amt, doc_trans_date
where doc_code = '&1';

 
sqlplus -s ${USER}/${PASS} <<EOF 1>>${LOG1} 
whenever sqlerror exit 1
        set serveroutput off;
        set echo off;
        set termout off;
        set linesize 600;
        set line 1000;
        set pagesize 5000;
        set newpage 0;
        set feedback off;
        set trimspool on;
        set trimout off;
        set define on;
        set verify off;
        set escape off;
        set colsep "|"
        set doc off;
        set define on;
        @jour360.sql
        quit;
EOF

#!/bin/sh

printf "Enter the database name: "
read DATABASENAME

sqlplus -s ${USER}/${PASS} <<EOF
        USE ${DATABASENAME};
        SHOW TABLES;
        QUIT;
EOF