i was working on a project and was wandering how can i search for a particular column or a table in Oracel PLSQL.
Here we go
SELECT * FROM USER_TAB_COL
SELECT * FROM USER_TAB_COLUMNS
The above queries will return information about all the columns and tables that are accessible to the user using the above query
You can search for a particular column like
SELECT * FROM USER_TAB_COL WHERE COLUMN_NAME='Column name'
You can search for a particular table in the same fashion
SELECT * FROM USER_TAB_COL WHERE TABLE_NAME='Column name'
I hope this will ease up you day-to-day activities. stay in touch for more tips