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, 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 Received on Fri Aug 31 2007 - 10:29:13 CDT