Connecting to Oracle through unix shell scripts

guptan · #1 (**permalink**) 07-04-2005

Hi,

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

Regards
Narayana Gupta

google · #2 (**permalink**) 07-04-2005

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

Code:

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

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Connecting to oracle database from shell script	satyakiran	Shell Programming and Scripting	8	07-03-2009 03:22 PM
Oracle Passwords in Unix scripts	clifford	Shell Programming and Scripting	5	05-16-2008 11:33 AM
Connecting to Oracle from Shell..What Am I doing Wrong	dzyr4tt	Shell Programming and Scripting	1	12-21-2006 01:05 AM
Difference between writing Unix Shell script and AIX Shell Scripts	haroonec	AIX	0	04-12-2006 02:27 AM
ORACLE from Shell scripts	mohanprabu	Shell Programming and Scripting	2	11-24-2004 12:11 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by