Show the structure of the table in SQL
To list columns and data types, I typically use
SELECT COLUMN_NAME, DATA_TYPE FROM ALL_TAB_COLUMNS WHERE TABLE_NAME='your_table_name';
It's been a while since I've worked with Oracle though.
ALL_TAB_COLUMNS might actually be
If you need to display the full
CREATE TABLE statement, see How to get Oracle create table statement in SQL*Plus