I need a way to iterate through all tables in tablespace "T_ECOS" and find all ID with null value in oracle database
Any suggestion?
functionsidentitynulloracleplsql
I need a way to iterate through all tables in tablespace "T_ECOS" and find all ID with null value in oracle database
Any suggestion?
Best Answer
You can do something like this to dynamically generate a query against the tables with a nullable ID column to see whether they actually contain nulls or not: