RE: sqlplus

  • From: "Rich Jesse" <rjoralist@xxxxxxxxxxxxxxxxxxxxx>
  • To: "oracle_l" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 6 Oct 2009 13:17:44 -0500 (CDT)

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 / @$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


--
//www.freelists.org/webpage/oracle-l


Other related posts: