Oracle Tip: Find columns in oracle database

If you already know the column name but are not sure which table it is in then you can use the sql below to find the table name:

SELECT table_name, column_name FROM all_tab_columns WHERE lower(column_name) like lower(‘%<column_name>%’);

replace <column_name> with the actual column name string (even a partial string will do).

19 comments for “Oracle Tip: Find columns in oracle database

  1. July 12, 2009 at 4:14 pm

    Rather interesting. Has few times re-read for this purpose to remember. Thanks for interesting article. Waiting for trackback

  2. December 17, 2010 at 9:12 am

    great post, thanks for sharing

  3. September 16, 2011 at 12:38 am

    Straight to the point and well written! Why can’t everyone else be like this?

  4. December 2, 2011 at 12:47 pm

    Hello, just wanted to mention, I liked this blog post. It was helpful. Keep on posting!

  5. December 23, 2011 at 1:21 am

    Excellent point here, seriously great info. Cheers!!

  6. December 26, 2011 at 8:35 am

    Great post!

  7. January 4, 2012 at 2:47 pm

    I’m still learning from you, as I’m trying to achieve my goals. I absolutely enjoy reading everything that is posted on your website.Keep the information coming. I enjoyed it!

  8. January 5, 2012 at 10:10 am

    It was a very nice idea! Just wanna say thank you for the information you have diffused. Just continue composing this kind of post. I will be a loyal reader, thanks a lot.

  9. January 17, 2012 at 1:57 pm

    Love your blog!

  10. February 15, 2012 at 12:46 pm

    Hello! I just would like to give a huge thumbs up for the great info you have here on this post. I will be coming back to your blog for more soon.

  11. February 19, 2012 at 11:32 pm

    That is the type of info that should be shared around the web. Shame on the search engines for now not positioning this higher up! Come on over and discuss with my web site. Thanks =)

  12. March 1, 2012 at 7:23 am

    This is very interesting, You are a very skilled blogger. I’ve joined your rss feed and look forward to seeking more of your magnificent post. Also, I have shared your site in my social networks!

  13. June 21, 2012 at 2:17 am

    I just want to say I am new to weblog and absolutely liked you’re blog site. Probably I’m planning to bookmark your blog post . You amazingly have beneficial article content. Appreciate it for sharing with us your blog site.

  14. June 15, 2014 at 9:34 am

    whoah this weblog is excellent i love reading your articles.
    Stay up the good work! You know, lots of persons are hunting
    round for this info, you can aid them greatly.

  15. August 20, 2014 at 4:33 am

    Great blog right here! Additionally your website rather a lot up very fast!
    What host are you the usage of? Can I get your associate link to your host?
    I desire my site loaded up as fast as yours lol

  16. August 20, 2014 at 6:27 pm

    Do you mind if I quote a couple of your articles as long as I provide credit and sources
    back to your website? My blog site is in the exact same niche as
    yours and my users would truly benefit from a lot of the information you provide here.
    Please let me know if this ok with you. Appreciate it!

  17. September 5, 2014 at 12:25 pm

    Pretty! This has been a really wonderful article. Thanks for providing this information.

  18. September 8, 2014 at 5:23 pm

    Hiya very nice blog!! Guy .. Beautiful .. Superb .. I’ll bookmark your site and take
    the feeds additionally? I’m satisfied to seek out so many helpful information here within the
    put up, we want develop more techniques in this regard, thank you for sharing.
    . . . . .

  19. September 16, 2014 at 7:06 pm

    This is a good tip particularly to those fresh to
    the blogosphere. Short but very accurate info… Appreciate your sharing this
    one. A must read article!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.