geeksdatabase » Database

    http://geeksdatabase.com

    Everything about everything.

    Fri, 04 Mar 2011 23:26:40 +0000

    en

    hourly

    1

    http://wordpress.org/?v=3.3.1

    How to search for a column name in the Oracle Database

    http://geeksdatabase.com/how-to-search-for-a-column-name-in-the-oracle-database/

    http://geeksdatabase.com/how-to-search-for-a-column-name-in-the-oracle-database/#comments

    Mon, 20 Apr 2009 22:30:58 +0000

    admin

    http://geeksdatabase.com/?p=106

    When you are working with Database systems, very often you will be stuck in a situation where you vaugely remember the column name but doesn’t know which TABLE the COLUMN belongs to. I’ve been in this situation more than a dozen times myself. I blame my bad memory for this.

    Well, here is a small SQL query that does the trick for you…

    ]]>

    When you are working with Database systems, very often you will be stuck in a situation where you vaugely remember the column name but doesn’t know which TABLE the COLUMN belongs to. I’ve been in this situation more than a dozen times myself. I blame my bad memory for this.

    Well, here is a small SQL query that does the trick for you.

    SELECT TABLE_NAME,COLUMN_NAME FROM USER_TAB_COLUMNS WHERE COLUMN_NAME like ‘%customer_id%’;

    Replace the “customer_id” with the text that you would like to search for.

    This works for a Oracle Database. I haven’t tried this with MySQL.

    Please use the comment box for any suggestions.

    ]]>

    http://geeksdatabase.com/how-to-search-for-a-column-name-in-the-oracle-database/feed/

    0

    Leave a Reply

    Your email address will not be published.

    geeksdatabase » Database

    http://geeksdatabase.com

    Everything about everything.

    Fri, 04 Mar 2011 23:26:40 +0000

    en

    hourly

    1

    http://wordpress.org/?v=3.3.1

    How to search for a column name in the Oracle Database

    http://geeksdatabase.com/how-to-search-for-a-column-name-in-the-oracle-database/

    http://geeksdatabase.com/how-to-search-for-a-column-name-in-the-oracle-database/#comments

    Mon, 20 Apr 2009 22:30:58 +0000

    admin

    http://geeksdatabase.com/?p=106

    When you are working with Database systems, very often you will be stuck in a situation where you vaugely remember the column name but doesn’t know which TABLE the COLUMN belongs to. I’ve been in this situation more than a dozen times myself. I blame my bad memory for this.

    Well, here is a small SQL query that does the trick for you…

    ]]>

    When you are working with Database systems, very often you will be stuck in a situation where you vaugely remember the column name but doesn’t know which TABLE the COLUMN belongs to. I’ve been in this situation more than a dozen times myself. I blame my bad memory for this.

    Well, here is a small SQL query that does the trick for you.

    SELECT TABLE_NAME,COLUMN_NAME FROM USER_TAB_COLUMNS WHERE COLUMN_NAME like ‘%customer_id%’;

    Replace the “customer_id” with the text that you would like to search for.

    This works for a Oracle Database. I haven’t tried this with MySQL.

    Please use the comment box for any suggestions.

    ]]>

    http://geeksdatabase.com/how-to-search-for-a-column-name-in-the-oracle-database/feed/

    0

    Leave a Reply

    Your email address will not be published.