Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL output substitutions
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.GIFReceived on Tue Apr 13 2004 - 16:35:12 CDT