Oracle - SQL - Like

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]

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