Extra space in sqlplus

[wojtek75]

Hi,

====
#!/bin/ksh

a=$(echo "set heading off\nselect status from v\$instance;"| sqlplus -s '/as sysdba')

print =$a=
===
and I get (please note a leading space):
= OPEN=

Can anybody tell me where this space come from? How to return the value without the space? I am not interested in external space removers (tr,sed,awk etc).

[Dennis Handly]

>Can anybody tell me where this space come from?

From your external sqlplus.

>I am not interested in external space removers

Why not? Do you want a shell builtin?
a=${a## }

[wojtek75]

Why sqlplus returns an extra space? How to avoid it?

I think a=${a##} doesn't work in my ksh Version M-11/16/88f.

[Dennis Handly]

>I think a=${a##} doesn't work in my ksh

Did you cut&paste my text, you lost the space.

[wojtek75]

You are correct, ## works fine. But still interested in why sqlplus returns extra space in fron of its output.

[Jean-Luc Oudart · Accepted solution]

could you add the sqlplus command :
set newpage none

Regards
Jean-Luc

[wojtek75]

this is exactly what I was looking for, thanks!