select COLUMN_NAME,NUM_DISTINCT from dba_tab_columns where table_name='&table_name' and OWNER='&owner';