Re: SQL*Plus problem

Ed.Stevens_at_nmm.nissan-usa.com <Ed.Stevens_at_nmm.nissan-usa.com> wrote:
>
>SPOOL tmp1.sql
>SET TERMOUT OFF HEADING OFF PAGES0 VERIFY OFF ECHO OFF FEEDBACK OFF
> SELECT 'SELECT DISTINCT TO_CHAR('||COLUMN_NAME||',''DD-MON-YYYY'')'||
> ' FROM ' || OWNER ||'.' ||TABLE_NAME||
> ' ORDER BY TO_CHAR('||COLUMN_NAME||',''DD-MON-YYYY'')'||
> ';'
> FROM DBA_TAB_COLUMNS;
>SPOOL OFF;
>@tmp1.sql
>
>The problem is that the resulting SELECT DISTINCT statement can resolve to a
>string that breaks into 2 lines when it, in turn, is processed by SQL*Plus.

I suppose you could just specify a large linesize and trim the blanks at the end by starting your script with something like:

set linesize 800
set trimout on
set trimspool on

I hope this will do the trick for you.
--

   @..@ Marti Rijken <mrijken_at_natrix.demon.nl>   (`--') at work: mrijken_at_prv.gelderland.nl  ( }..{ ) URL: http://www.natrix.demon.nl/ Received on Thu Jan 07 1999 - 01:41:54 CST