Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Query to Find Table and Column Name by using a value

karthiksingh_dbaSep 3 2013 — edited Sep 3 2013

Dear Legends,

I hope and surfed in our forums and google to find the Table Name and Column Name by having a value(Number/String). And my where clauses are

where owner NOT IN ('SYS','SYSTEM') and

      data_type IN ('CHAR','VARCHAR2','NUMBER')

May I have your help for building the query. and my query as follows

select a.owner, c.column_name, c.data_type, c.owner, c.table_name

from dba_objects a, all_tab_cols c

where a.owner NOT IN ('SYS','SYSTEM') and

where c.owner NOT IN ('SYS','SYSTEM') and

where c.data_type IN ('CHAR','VARCHAR2')

order by a.owner

Thanks,

Karthik

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 1 2013
Added on Sep 3 2013
3 comments
6,775 views