Member Avatar for Venus_3
Venus_3 0 Newbie Poster

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..

Edited by Venus_3
  • 1 Contributor
  • 0 Replies
  • 211 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.