Oracle databases organize tables into owner accounts called schemas. Database users with varying privileges can query the database metadata – called the “data dictionary” – to list information including column names, object permissions or object statistics. To obtain column names from tables or views on an Oracle database server, run a short query using the most appropriate data-dictionary object. The USER_TAB_COLS view shows objects owned by the logged-in user, whereas ALL_TAB_COLS shows all objects available to the user given his permissions and DBA_TAB_COLS shows everything in the database irrespective of which user account owns the object. SELECT * FROM USER_TAB_COLS; Substitute ALL_TAB_COLS or DBA_TAB_COLS as appropriate. The “*” symbol returns all columns in the query. SELECT owner, table_name, column_name FROM ALL_TAB_COLS; SELECT * FROM USER_TAB_COLS WHERE table_name LIKE ‘A%’; Tips Warnings Writer Bio
