Shell Programming and Scripting

Hi Gurus,

I need check existing number of file based on the list in file list.
for example:
in my file list. I have below:

Code:

abc, file1.txt
abc, file2.txt
abc, file3.txt
abc, file4.txt
cde, filea1.txt
cde, filea2.txt
cde, filea3.txt
...

in my current file direcotry, I have file:

Code:

file1.20130502.txt
file2.20130502.txt
file3.20130502.txt
file4.20130502.txt
filea1.20130502.txt
filea2.20130502.txt

there 4 files for first group abc, after remove date partition (20130502) the files are completed, so, I need log into DB through sqlplus run query select count(*) from tab where group = 'abc', if count(*) > 0 then do nothing, if count(*) = 0 then call another script.
for group cde there is one file missing, I need send warning.

anybody can help me this?

Thanks in advance.