Show the structure of the table in SQL

sql sqlplus

Try this out: describe table_name

sql sqlplus

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 ALL_TAB_COLS.

If you need to display the full CREATE TABLE statement, see How to get Oracle create table statement in SQL*Plus

sql sqlplus

You can use sqlplus command describe <SCHEMA_OWNER.TABLE>

CodeHunter