select columns from a table ORACLE code example

Example: oracle list columns in schema

SELECT *
FROM all_tab_cols;