oracle list columns in schema
snippet in sql

oracle list columns in schema

user2163

SELECT *
FROM all_tab_cols;