This is an old revision of the document!

Oracle - SQL - Like

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%'

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