Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Converting Data types using SQL
On Aug 31, 11:29 am, vitalis..._at_gmail.com wrote:
> On Aug 31, 4:56 pm, ci..._at_yahoo.com wrote:
>
> > select *
> > from table_definitions
> > where service_description = 'TBD';
>
> LONG columns cannot be used in WHERE clauses.
> Convert the column to CLOB and user to_char() in your WHERE clause.
>
> Jerome
Thank you for your reply, but I cannot convert the column within the table. I was trying to find a way to do this within the sql statement. But, from what you are telling me, it cannot be done via sql, it has to be changed in the oracle table itself. Received on Fri Aug 31 2007 - 11:51:32 CDT