handling Multiline SQL outputs - The UNIX and Linux Forums

		The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
handling Multiline SQL outputs

google unix.com

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

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
compare 2 outputs	melanie_pfefer	Shell Programming and Scripting	1	05-21-2008 10:20 AM
Multiline Grep	tolmark	UNIX for Dummies Questions & Answers	4	03-14-2008 12:31 AM
transforming a multiline record to single line	anju	Shell Programming and Scripting	9	01-14-2008 07:55 AM
Awk Compare Files w/Multiline Records	RacerX	Shell Programming and Scripting	4	12-21-2007 06:05 AM
Printing outputs using awk.	Krrishv	Shell Programming and Scripting	4	01-09-2007 07:31 AM


	Powered by

LinkBack

Thread Tools

Search this Thread

Rate Thread

Display Modes

#1 (permalink)

01-08-2008

decci_7

Registered User

Join Date: Sep 2006

Posts: 17

handling Multiline SQL outputs

Hi,

I'm using KSH and calling a SQL statement inside my script which returns more than 1 record.

Code:

Result=`sqlplus -s $DB_USER/$DB_PWD@$DB_STRING <<END
set echo off
set head off
spool junk.txt
select Name from abc where job = 'Manager';
spool off
exit;
END`

echo $Result

The above SQL returns 3 names as:

Quote:

Tom Hanks
Harry Potter
John

But when i'm calling this SQL in my script and assigning the Result to a variable "Result" and echoing the same, the result comes out in a single line like below:

Quote:

Tom Hanks Harry Potter John

What I require is the output should be assigned to the variable result in the below format so that I can seggregate the records:

Quote:

Tom Hanks
Harry Potter
John

Is there any way i can achieve such result?

Thanks in advance.

Bookmarks

« RegExp: From first occurrance to last (at line start) | DB2 and Unix Variable ..... »

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

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On Forum Rules

All times are GMT -4. The time now is 08:52 AM.