Skip to Main Content
  • Questions

  • Query all tables and all columns for a specific value

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, John Lore.

Asked: September 26, 2018 - 9:36 am UTC

Last updated: September 27, 2018 - 4:27 am UTC

Version: 12c

Viewed 10K+ times! This question is

You Asked

Hi Oracle Masters,

I wonder if oracle is capable of returning the table name and column name based on a specific value only. e.g. Which table and column in oracle DB that has a value of 'ORACLE'?

This is mainly for determining the mapping of the data.

Thanks!

and Connor said...

Not without writing your own.

Take a look here for an example

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:37336026927381#42426083757635



Is this answer out of date? If it is, please let us know via a Comment
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

SQL

The Oracle documentation contains a complete SQL reference.