How to search on LONG datatype column

Hi All,

I want to search something based on search_condition. Since search_condition column is LONG data type I could not use "like" or "=" operator.

Any idea?

SELECT * FROM dba_constraints a,dba_cons_columns b WHERE a.constraint_name=b.constraint_name and owner='USERNAME1'
AND table_name='TAB_NAME'
AND Column_name='COLUMN_NAME'
AND generated='GENERATED NAME'
--AND search_condition like 'LogOffMode in (''A'')'

--

Sami Seerangan
Oracle DBA
--

http://www.freelists.org/webpage/oracle-l Received on Tue Oct 26 2004 - 13:37:41 CDT