Skip to Main Content
  • Questions

  • i need to find the table name and column name using column values.

Breadcrumb

Question and Answer

Tom Kyte

Thanks for the question, M.

Asked: December 09, 2008 - 1:29 pm UTC

Last updated: December 09, 2008 - 5:10 pm UTC

Version: 10g

Viewed 1000+ times

You Asked

PL/SQL

I have a specified column value like " moe_2002_acso_link" . form this i need to find the table name and column name where the data presents ??

im not sure is it possible or not !! but still ny one can help me out this!
like i need the out put like

Table Name Column Name
AAAA AAAA
BBBB NBB


the column names AAAA,NBB from the table AAAA,BBBB havin the data called 'moe_2002_acso_link' . is it possible?

Regards,

and Tom said...

I think you mean this...

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


be prepared to wait and wait and wait for an answer as it will involve lots of full scans of course...

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 channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.