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!

Finding columns using all_tab_columns

837064Feb 4 2011 — edited Feb 5 2011

I am using oracle 11g and i am having trouble finding a column name using all_tab_coulmns .Basically i dont know the exact name of the column and i used wild card in the where clause but i seems line wild card doesnt work.Could this be because of the reason that the column names are case sensitive.Query that i used is listed below.

select * from all_tab_columns where column_name='%sequence%'.What i wanted out of this query was, all the columns that have 'sequence' in it and FYI i used uppercase as well.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 5 2011

Added on Feb 4 2011

#database, #pl-sql, #plsql, #sql

4 comments

944 views