How to search on LONG datatype column
- From: Sami Seerangan <dba.orcl@xxxxxxxxx>
- To: Oracle Discussion List <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 26 Oct 2004 14:41:48 -0400
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
