Shell scripting and SQL - The UNIX and Linux Forums

		The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
Shell scripting and SQL

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
Regarding Shell Scripting	anilkarikkandar	UNIX for Dummies Questions & Answers	3	11-20-2006 12:26 AM
HELP PLS!! Shell Scripting!!	Mary_xxx	Shell Programming and Scripting	9	09-16-2006 07:52 AM
difference between AIX shell scripting and Unix shell scripting.	haroonec	Shell Programming and Scripting	2	04-12-2006 09:12 AM
something else on shell scripting	master_6ez	Shell Programming and Scripting	1	11-21-2004 11:42 PM


	Powered by

LinkBack

Thread Tools

Search this Thread

Rate Thread

Display Modes

#1 (permalink)

04-22-2006

sendhilmani123 sendhilmani123 is offline

Registered User

Join Date: Apr 2006

Posts: 33

Shell scripting and SQL

Hi,

I have a file that has contents like this:
SQL> select * from details;

NAME REG
-------------------- ----------
Mani 1
Santosh 2
Manju 3
Mukesh 4

SQL> spool off;

I want to remove the first line'select * from details' and the last line 'spool off'. I also want to remove the lines 'Name Reg and the line below them' and also introduce a new field seperator between values. How can I do it.

Bookmarks

« SORT Cammand | cp: cannot access?? »

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 11:41 PM.