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 -> Converting Data types using SQL

Converting Data types using SQL

From: <ciojr_at_yahoo.com>
Date: Fri, 31 Aug 2007 07:56:49 -0700
Message-ID: <1188572209.090495.304020@r29g2000hsg.googlegroups.com>


I have a table that has a column that is a data type of "LONG". The data in this column is actually text (it's descriptions). Don't know they history of why it was set up this way, but I cannot change it. So, I am trying to use SQL to pull this column along with other columns in the table. In my where clause I need to use the column in question (which is called "service_description", for example) to limit
the data I am pulling back. However, SQL does not allow me to use the CAST or CONVERT or SUBSTR functions to convert the data in the field. I get the error ORA-00997: illegal use of LONG datatype or ORA-00932:
inconsistent datatypes: expected NUMBER got LONG or some other ORACLE error.
Is there some way to do this? I cannot change the data type of the column, so I have to convert the data in the sql in order to use it in
my where clause.
Thanks.

select *
from table_definitions
where service_description = 'TBD'; Received on Fri Aug 31 2007 - 09:56:49 CDT

Original text of this message

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