You are missing 2 )'s for the 2 rtrims.
SQL> select rtrim (to_char(sys_sbb)) || ','||
2 rtrim (to_char(prin_sbb)) ||','||
3 FROM SBB_BASE;
Jim
"Peter" <pmclinn_at_mclinn.com> 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) ||','||
> 3 FROM SBB_BASE;
Received on Wed Nov 28 2001 - 11:51:45 CST
