i'm trying to find in all tables with data in all columns..
example
EMPLOYEE table with ID = 123
COLUMNS DATA
ID 1
NAME TEST
ADDRESS TESTADDRESS
PHONE
EMAIL
POSITION DEV
The output will be ID, NAME, ADDRESS, and POSITION.. so basically all columns with data only..
by the way, i can't rely on NUM_DISTINCT in USER_TAB_COLUMNS..