connect to sqlplus in a script | Unix Linux Forums | Shell Programming and Scripting

  Go Back    


Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here.

connect to sqlplus in a script

Shell Programming and Scripting


Closed Thread    
 
Thread Tools Search this Thread Display Modes
    #1  
Old 09-18-2006
big123456 big123456 is offline
Registered User
 
Join Date: May 2005
Last Activity: 20 March 2013, 11:06 AM EDT
Posts: 288
Thanks: 8
Thanked 0 Times in 0 Posts
connect to sqlplus in a script

Hi,
I want to write a script, in which I will connect to sqlplus and do a quary and then exit
sqlplus user/pwd@database
select count(*) from table
exit.
and write the result in a log file.

How to write it ?
Many thanks before.
Sponsored Links
    #2  
Old 09-18-2006
Dhruva's Avatar
Dhruva Dhruva is offline
Registered User
 
Join Date: Mar 2006
Last Activity: 2 November 2012, 12:45 AM EDT
Location: India
Posts: 255
Thanks: 0
Thanked 1 Time in 1 Post
This is answer
check the above link same question was answered there.
please use search on forum you will find plenty of same thread.
Sponsored Links
Closed Thread

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
(Urgent):Creating flat file using sql script and sqlplus from UNIX Shell Script praka Shell Programming and Scripting 6 04-15-2009 07:09 AM
connect sqlplus from unix nehak UNIX for Dummies Questions & Answers 1 05-27-2008 09:12 AM
help me in sending parameters from sqlplus script to unix shell script Hara Shell Programming and Scripting 2 01-29-2008 03:31 PM
connect to sqlplus from shell aya_r Shell Programming and Scripting 4 02-07-2007 05:52 AM
SQLPLUS in script renichols Shell Programming and Scripting 4 03-06-2006 12:43 PM



All times are GMT -4. The time now is 01:13 PM.