Originally posted by Pinakin
Originally posted by Pinakin
USER_TAB_COLUMNS
or in ALL_TAB_COLUMNS for all tables of all users.
Better make it DBA_TAB_COLUMNS.

USER_* - about objects you own
ALL_* - about objects you have access to
DBA_* - about all objects in the database (you have to have DBA privileges to use this)