Connecting to Oracle through unix shell scripts

UNIX for Advanced & Expert Users
1

Hi,

Can some one help me in connecting to oracle through unix shell scripts with examples.

Regards
Narayana Gupta

2

Use a HERE document. Search the forum for Oracle or HERE document to find several other examples.

$ORACLE_HOME/bin/sqlplus -s <<SQLPLUS > oracle.log 
$DB_id/$DB_pswd@$DB_server 
select to_char(sysdate,'YYYYMMDDHHMMSS') FROM dual; 
spool off 
SQLPLUS