Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL output substitutions

Re: PL/SQL output substitutions

From: Joel Garry <joel-garry_at_home.com>
Date: 13 Apr 2004 14:35:12 -0700
Message-ID: <91884734.0404131335.114e0d4b@posting.google.com>


weberm_at_polaris.net (Ubiquitous) wrote in message news:<c5h1j2$8he$1_at_news.utelfla.com>...
> I have this PL/SQL stored procedure which produces a columnar report.
> When I run it in SQL*PLUS, the columns are all aligned, however, when
> I run it via an UNIX shell script which pipes the report to a file, I
> discovered some of the white space gets converted to tabs! Has anyone
> ever experienced this before? I'm at my wit's end trying to figure out
> what's going on. I include a sample of the PL/SQL code and output that
> was emailed below, in case it helps.
>
> Thanks in advance,
> MRW
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a90842/ch13.htm#1013293

Note default. Test with SHOW ALL.

jg

--
@home.com is bogus.
100 Sparc 1's running for a month made this ten years ago: 
http://www.cpjava.net/raytraces/DRUN.GIF
Received on Tue Apr 13 2004 - 16:35:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US