Basic question, my loop is like this. Retreiving all the columns from data dictionary and do some mappings...
FOR user_tab_col IN
(SELECT column_name FROM user_tab_columns
WHERE table_name = <table_name>
AND column_name LIKE 'V5%'
ORDER BY column_name)
--- Mappings ---
I want to add 1 more condition to check the column exists in another table (new table) or not.
If exist I will do the mappings, If not I will assign it to Null value. Either case I need the column name.
Please can anyone suggest the better way to fix this.