Re: How to concatenate two lines of result from sqlplus
From: lovecreatesbea..._at_gmail.com <lovecreatesbeauty_at_gmail.com>
Date: 7 Nov 2006 00:03:21 -0800
Message-ID: <1162886601.351331.198210_at_e3g2000cwe.googlegroups.com>
Date: 7 Nov 2006 00:03:21 -0800
Message-ID: <1162886601.351331.198210_at_e3g2000cwe.googlegroups.com>
"Michel Cadot дµÀ£º"
> I also want to ask for your help on another question. I have set
>
> set feed off
> set echo off
>
> but I still get the result of the select statement on the UNIX command
> terminal. What was I missing?
>
> -----------------------------
> use "set termout off" to eliminate output on your terminal.
Thank you Michel.
I tried that sql*plus command. Finally, the echo to the terninal was suppressed by file redirection operation on my machine,
sqlplus -silent ""$user"/"$pass"_at_"$db_ins"" <<-EOF > /dev/null 2>&1
...
EOF Received on Tue Nov 07 2006 - 09:03:21 CET