Shell Programming and Scripting

ABCD_TV_YYYYMMDD.txt                  YYYYMMDD
ABCD_MOUSE_YYYYMMDDHHMISS.txt           YYYYMMDDHHMISS

ABCD_TV_20160822.txt 
ABCD_MOUSE_20160814062822.txt

cat script.ksh
### Here I am taking an example of sql db.
cat << EOF > sql_file.sql
select filenames from t_filenames;
EOF

sqlplus user_name/password@schema_name < sql_file.sql > output_file
#### Here we need to remove junk lines from file output_file which we will get once we connect to client. eg--> connected to: SQL*PLUS version etc.
which I can't predict until/unless you post output for above query with code tags here. So assuming we have removed those lines and have them into a file named output_file_names.
awk '{if($0 !~ /SQL*plus/ && $0 !~ /connected to/){print}}' output_file > output_file_names
while read line
do
	if [[ -f "/tmp/$line" ]]
	then
		echo "File named " $line " is present."
	else
		touch "/tmp/$line"
	fi
done < "output_file_names"