Wednesday, September 16, 2015

How to get all the tables with the column name

How to get all the tables with the column name?

Using below query you will get column names.
 
SELECT  TABLE_NAME FROM
  all_tab_columns
WHERE column_name = '<COLUMN_NAME>'

3 comments:

Clear BNE Cache for WebADI Changes

It Sometime happens that WebAdi Changes doesn't reflect once migrated in controlled instances. Here are the quick steps(Generally perfor...