Document Type | Technical Information
Category | App Development
Document Number | TDETI003
Overview
This explains how to create and use queries with the REGEXP_LIKE() function when you want to assign multiple arguments to LIKE IN as shown in the query below.
select distinct a.table_name from dba_tables a, dba_tab_columns b where a.table_name=b.table_name
and a.data_type like in ('%LONG%', '%LOB%')
and a.owner='TIBERO'
order by 1;
Method
The method to assign multiple arguments to LIKE IN by composing a query with the REGEXP_LIKE() function is as follows.
select distinct a.table_name from dba_tables a, dba_tab_columns b where a.table_name=b.table_name and REGEXP_LIKE(b.data_type, 'LOB|LONG') and a.owner='TIBERO' order by 1 ;