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
Solved! Go to 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