I have file called
objects.txt contains tables and columns as below.
Part:1 Table_name: customer1 Column_name: account_no Part:2 Table_name: customer2 Column_name: purchase_id . . Part:n
Now, I want to pick this table_name and column_name from the file as two variables in a loop and send to the
sqlplus to run the below query.
For tab in grep of table_name For col in grep of column_name Set table=$tab Set column=$col Set Null_check='sqlplus -s/@$oracle' ‹‹ENDOFSQL set serveroutput on; Select count(*) from (select $column from $table where $column is null); Exit ENDOFSQL
Please help me how to loop the this two variables in single for loop iteration and send to this SQL query
Go to Source
Author: dinesh valavala