====== Oracle - SQL - Like ======

<code sql>
SELECT column_name(s)
FROM table_name
WHERE column_name LIKE pattern
ORDER BY 	SELECT column_name(s)
FROM table_name
ORDER BY column_name [ASC|DESC]
</code>

<code sql>
select * from DB_DESIGNER.GB_STAGING_CONTROL 
where BASE_NAME like '%DIST%' 
or BASE_NAME like '%CREDIT%' 
or BASE_NAME  like '%REBATE%'
or BASE_NAME like '%PHARMA%'
</code>

<code sql>
SELECT e.BASE_NAME
FROM DB_DESIGNER.GB_STAGING_CONTROL e,
(
select
decode(level,
1, '%DIST%',
2, '%CREDIT%',
3, '%PHARMA%') n
from dual
connect by level <=3
) l
WHERE e.BASE_NAME LIKE l.n
</code>