App Muncher

Issues faced - solutions identified - shared with community.

In ORACLE we have a view called "cols", it can be used to ascertain which table contain a given column:

SELECT table_name, column_name
FROM cols
WHERE table_name LIKE 'RECEIVE%'
AND columns_name LIKE '%amount%';

This will find all tables which begin with RECEIVE and contains columns name containing the word amount in its name.

No comments:

Post a Comment

| Designed by AppMuncher