We have a large Oracle database with many tables. Is there a way I can query or search to find if there are any tables with certain column names?
IE shows me all tables that have the columns: id, fname, lname, address
The detail I forgot to add: I need to be able to search through different schemas. The one I must use to connect doesn't own the tables I need to search through.