table definition as select-result 1

[stwi1974]

Hi!

is there any possibility to get the table-definition as result from a select, like SQL-Plus' DESC?

thx in advance

 

[JediDan]

The sys view ALL_TAB_COLUMNS probably has what you're looking for.

Try this:

SELECT column_name, data_type, data_length, data_scale, nullable, data_default
FROM all_tab_columns
WHERE table_name = <table_name>

Good luck

 

[stwi1974]

Thx for your hint, JediDan!
but all_tab_columns doesnt recieves anything (isnt filled) but the result of all_views gave me all_tab_cols which is fits all i wanted

zerberus