Shell Programming and Scripting

I have a variable in a shell script which is more than 80 characters.
1) I log into SQL plus and populate a variable using 3 queries appended by ,' comma'.
ORAINFO=`sqlplus -s << !
/ as sysdba
set feedback off
set heading off
select LOG_MODE ||','||(select substr(VALUE,instr(VALUE,'=')+1) from V\\$PARAMETER where NAME='log_archive_dest_1')
||','||(select max(BYTES) from V\\$LOG ||','||(select VALUE from V\\$PARAMETER where NAME='background_dump_dest')
from V\\$DATABASE;
exit
!`

2) It gives a value ArchiveLOG,46464545434,/u05/app/oracle/product/8.1.6/admin/FCCLIVE/bdump. However it displays a space after FCCLIVE/, so effectively it becomes FCCLIVE/ bdump instead of FCCLIVE/dump.


Request your help;...

You don't actually ask a question in your post....

What is your problem (is it the fact that there is a space in the output)?

And what is the solution you're looking for (is it to remove the space)?

If you're sure you won't get any legitimate spaces in your output you can just pipe ORAINFO through sed to remove the spaces thusly

Code:

NOSPACES=`echo "$ORAINFO" | sed 's/ //g'`

If that's not what you want please give a little more information....

Cheers
ZB

yes sorry for the vague question.
I dont want the space in my variable o/p. However after I posted the thread, I was looking into sqlplus manual and there I found out what the problem was. SQLPLUS was limiting factor, not Unix Col size. So after setting linesize=100, it worked.

Thanks for the help rendered