Oracle columns list and tables

Oracle has a great table that will give you some great meta data about your other tables and columns called “all_tab_cols“.


I have only included 5 of what I think are the most important columns but there are lots of others you might need to do a “Select *” and see what you get

But that is only the beginning then you should export those results and pivot them in Excel and this will give you a list of columns and what tables they have in common.

Leave a comment