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