Re: Quick sqlplus cr/lf question

From: Vince <vinnyop_at_yahoo.com>
Date: 8 Aug 2006 11:08:29 -0700
Message-ID: <1155060509.254728.203990@75g2000cwc.googlegroups.com>

BD wrote:
> > you don't have any sql posted that includes chr(10), so that problem can't
> > be diagnoses
>
> Ah yes - well, I tried _exactly_ what you had suggested, including the
> pipes. Here's the line I used, and the result:
>
> --SELECT STATEMENT
> select '*********************' || chr(10) ||,
> 'TRAINING SLICE COUNTS' || chr(10) ||,
> '*********************' || chr(10)
> from dual;
> ---------------------------------------
> -ERROR
> select '*********************' || chr(10) ||,
> *
> ERROR at line 1:
> ORA-00936: missing expression
> ---------------------------------------
>

Is not working because of the extra "," characters. Simply remove them thusly:

--SELECT STATEMENT

select '*********************' || chr(10) ||
        'TRAINING SLICE COUNTS' || chr(10) ||
       '*********************' || chr(10)

from dual; Received on Tue Aug 08 2006 - 13:08:29 CDT