Oracle: get column information from a table

Query the tables user_tab_columns or all_tab_columns: 

select column_name, data_type, data_length from user_tab_columns where table_name = 'MY_TABLE';

select * from all_tab_columns where owner = 'THE_SCHEMA_OWNER';

Source