How to extract table definitions using Query in Oracle?

 If you are using some tools, you can select the table for which you want to show properties and then Right-click the table and choose Properties. you will see definitions in the table.

1. View TB Definition by Right-Click on tools

2. View Definition  by Query

Following the query below, it will show all table definitions so easily, and quickly, and can view multiple tables at the same time...

SQL QUERY

SELECT COLUMN_NAME, DATA_TYPE, DATA_LENGTH

FROM user_tab_columns

WHERE table_name = 'TABLE_NAME'

ORDER BY column_id;