Programming

 
Say items =(MTH,WKL,DLY,QTR)

 
SELECT * FROM tb_data_storage
WHERE items IN ('MTH');

 
SELECT * FROM tb_data_storage
WHERE items IN ('MTH')
and value in ('ABC','GHN');

 
SELECT * FROM tb_data_storage
WHERE items IN ('WKL');
and value in ('XXX','YYY');
etc

 
ITEMS IN  ('MTH') AND  value in ('ABC','GHN')
OR
ITEMS IN ('WKL') AND  value in  ('XXX','YYY')
OR 
etc

items='MTH,WKL,DLY,QTR'

echo $items | tr ',' '\n' | while read item
do
   sqlplus -s ${user}/${pass}@${inst} << EOF
   --use the variable item in SQL here--
   EOF
done

items='(MTH,WKL,DLY,QTR)'
echo $items | sed 's/(//g; s/)//g'