One of my colleague today come to me asking where can i find this column (LANDING_PAGE) in DB of our application. Actually he was not even sure of the column name. It was a field in UI. Our application has more than 200 tables and my tables are heavy (having many columns). So human search was futile. Thankfully there is a query in oracle which came to rescue.
select * from user_tab_columns where column_name like '%PAGE%';
select * from user_tab_columns where column_name like '%PAGE%';
No comments:
Post a Comment