Tom's Guide | Tom's Hardware | Tom's Games

Computing.Net > Forums > Unix > Unix shell script problem...

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Unix shell script problem...

Reply to Message Icon

Name: premalm
Date: May 5, 2004 at 09:17:22 Pacific
OS: windows 2000
CPU/Ram: -
Comment:

Hi Guys,

I have a unix shell script which is like this...

sqlplus -s $FEB_UID/$FEB_PWD@feb_dev |&
print -p "select '|'||job_id||'|' from jobreq where status = 'PENDING';"
print -p "exit"
while read -p LINE
do
Item1=${LINE}
print ${Item1}
done

when I run the shell script the output is
'|'||JOB_ID||'|'
-------------
|116|
|117|
|118|
|119|
|120|
|121|

I only want the nos in ITEM1 variable ? how do i do this ?
any ideas ?

Thanks
Premal




Sponsored Link
Ads by Google

Response Number 1
Name: Dlonra
Date: May 5, 2004 at 14:42:17 Pacific
Reply:

isn't there a "no headings" option in slqplus?


0
Reply to Message Icon

Related Posts

See More



Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Unix Forum Home


Sponsored links
Ads by Google


Results for: Unix shell script problem...
Unix Shell Script www.computing.net/answers/unix/unix-shell-script/3580.html

Unix shell script runing SQL files www.computing.net/answers/unix/unix-shell-script-runing-sql-files/5286.html

Shell script problem www.computing.net/answers/unix/shell-script-problem/4434.html