executing a SQL query in shell script

lijju.mathew · #1 (**permalink**) 05-17-2007

Hi ALL,

I need an help in connecting to oracle database, executing a select query and printing it on the screen. Can any one please write a simple code or psuedo code and let me know.

select query returns multiple values( say select name from emp)

Thanks in advance
LM

Shell_Life · #2 (**permalink**) 05-17-2007

Lijju,
Yesterday you had a very similar post:
Calling PL/SQL Script in Shell Programming
Beware of the rules:

Quote:

(4) Do not 'bump up' questions if they are not answered promptly. No duplicate or cross-posting and do not report a post or send a private message where your goal is to get an answer more quickly.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
C Shell Script query	bpupdown	Shell Programming and Scripting	1	05-13-2008 07:38 PM
Need Unix script for executing oracle query	ravi gongati	Shell Programming and Scripting	14	03-24-2008 05:53 AM
Script executing sql query	kingluke	Shell Programming and Scripting	2	01-23-2008 01:57 PM
Executing Sql Query Using Shell Script	ragha81	Shell Programming and Scripting	14	07-31-2006 02:15 PM
Executing a SQL query from a shell script	98_1LE	UNIX for Dummies Questions & Answers	3	03-23-2002 03:29 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