show table structure in oracle

To get all details of oracle table use the following query.

SELECT to_char(DBMS_METADATA.GET_DDL('TABLE','tablename')) FROM dual