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 -> How to use LONG field in the Where clause

How to use LONG field in the Where clause

From: Rangeshwara Reddy Kona <konareddy_at_hotmail.com>
Date: Tue, 13 Nov 2001 21:03:22 -0800
Message-ID: <3bf1fb15@news.cadence.com>


Hi all,

Message contain date like 'Reached bad state' 'Error' I want to find the records which are having 'Error' in it. I can't use
select * from atc_message_log where msg_content like '%Error%'; Thanks in Advance.
Rangesh

SQL> desc atc_message_log;

 Name                                      Null?    Type
 ----------------------------------------- -------- ------------------------
---

 OBJ_ID                                    NOT NULL NUMBER(9)
 COMP_ID                                   NOT NULL NUMBER(9)
 INTEGRATION_ID                            NOT NULL VARCHAR2(300)
 WORK_UNIT_ID                              NOT NULL NUMBER(9)
 MSG_NBR                                   NOT NULL NUMBER(9)
 TIMESTAMP                                 NOT NULL DATE
 SEVERITY                                           NUMBER(5)
 MSG_CONTENT                                        LONG

SQL>
Received on Tue Nov 13 2001 - 23:03:22 CST

Original text of this message

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