RE: sqlplus
From: Rich Jesse <rjoralist_at_society.servebeer.com>
Date: Tue, 6 Oct 2009 13:17:44 -0500 (CDT)
Message-ID: <80b76ceb0c231c04ea98fdf97bdb7ada.squirrel_at_society.servebeer.com>
Hi Bambi,
Date: Tue, 6 Oct 2009 13:17:44 -0500 (CDT)
Message-ID: <80b76ceb0c231c04ea98fdf97bdb7ada.squirrel_at_society.servebeer.com>
Hi Bambi,
> Wait, wait, wait. Careful there with colsep. Setting that to "" will
> remove the space between columns in a report. So,
Good catch! Of course, my example:
>> my_status=`sqlplus -s / _at_$ADMIN/my.sql|cut -f 10 -d " "`
...has the implication of returning a single value. But I neglected to point that out, which certainly could lead to the "fun" results you showed.
Thanks!
Rich
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Oct 06 2009 - 13:17:44 CDT