When you "DESCRIBE My_Oracle_View" in SQL*Plus, where is Oracle getting the structure information for that view? Specifically, I want to retrieve the view structure [columns, data types, data_length, etc] the same way you would for a table from the USER_TAB_COLUMNS view.
The "Text" column from the User_Views view is NOT what I am after either.
TIA!
Mark McCasland
Midlothian, TX USA