DB Table structure

[Krish]

could you please help me in getting table structure details for oracle db table?

I used input data tool and connected oracle db.But I could not use desc table or sp_help table kind of statements.

Any idea?

Regards,

Krishna 

[Krish · Accepted solution]

With this query in the tool,

SELECT  table_name, column_name, data_type, data_length FROM all_tab_columns where table_name = 'Table Name'

I am able to extract structure data