Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> How to use LONG field in the Where clause
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
![]() |
![]() |