topic Re: Extra space in sqlplus in Operating System - HP-UX

Extra space in sqlplus

wojtek75 — Mon, 28 Sep 2009 09:19:50 GMT

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).

Re: Extra space in sqlplus

Dennis Handly — Mon, 28 Sep 2009 09:27:41 GMT

>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## }

Re: Extra space in sqlplus

wojtek75 — Mon, 28 Sep 2009 09:31:17 GMT

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.

Re: Extra space in sqlplus

Dennis Handly — Mon, 28 Sep 2009 09:33:56 GMT

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

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

Re: Extra space in sqlplus

wojtek75 — Mon, 28 Sep 2009 09:43:04 GMT

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

Re: Extra space in sqlplus

Jean-Luc Oudart — Mon, 28 Sep 2009 09:43:31 GMT

could you add the sqlplus command :
set newpage none

Regards
Jean-Luc

Re: Extra space in sqlplus

wojtek75 — Mon, 28 Sep 2009 09:45:42 GMT

this is exactly what I was looking for, thanks!