Re: Oracal Conversion Issue

From: Ed prochak <ed.prochak_at_alltel.com>
Date: 30 Nov 2001 09:47:44 -0800
Message-ID: <e51b160.0111300947.5923523b@posting.google.com>

pmclinn_at_mclinn.com (Peter) wrote in message news:<c4e93d03.0111280948.4a8d549c_at_posting.google.com>...
> I'm trying to export a file but I keep getting the following err:
> ORA-00936: missing expression
>
> Here is my code? What do you think?
>
> SQL> select rtrim (to_char(sys_sbb) || ','||
> 2 rtrim (to_char(prin_sbb) ||','||

you are missing an expression here---^^^^^^^^

> 3 FROM SBB_BASE;
either add another object to concatenate  or remove the last concatenate || operator

and the closing parentheses as another poster noted.

Enjoy. Received on Fri Nov 30 2001 - 11:47:44 CST