Sqlplus_Oracle8i

[Arun_39]

hi Bryson,
urs is working fine.

i need the output as align format.

[Yogeeraj_1]

hi,

you can use chr(9)


for instance, one easy way would be, assuming the version is always 8.1.7.4.0, you can do a replace of 8.1.7.4.0 with chr(9)||'8.1.7.4.0'...


nb. chr(9) = tab character

hope this helps!

regards
yogeeraj

[Keith Bryson]

This works - but it's dirty!!! If your version number changes, it'll stop working:

cat /tmp/output | awk -F"-" {'print $2'} | cut -c2- | awk -F"8.1" {'print $1"\t8.1"$2'}

Keith