Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Converting Data types using SQL

Re: Converting Data types using SQL

From: <vitalisman_at_gmail.com>
Date: Fri, 31 Aug 2007 08:29:13 -0700
Message-ID: <1188574153.949659.73800@g4g2000hsf.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US