Getting column definitions

[migregg]

I am implementing a schema browser and am getting information from the dictionary views such as user_tables. I then put this in a list and let the user select a table. Once I've selected a table, what would be the best way to retrieve the column definitions for that table? Is there another view for column definitions?

Michael Gregg

 

[Marco Kalter]

For the user_tables you can find the column definitions in the user_tab_cols view (where table_name = :selected_table).

------------------
Marco Kalter
Allround Automations