In sqlplus What query would you use to determine the most popular (the column name that appears the most frequently) column name in the tables of your database?
In sqlplus What query would you use to determine the most popular (the column name that appears the most frequ
select column_name, count(*)
from user_columns
group by column_name
order by count(*)
;
This will show each column name and the number of times it appears in tables. The one with the most occurances will be a the bottom of the list.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment