Oracle: Is there a way to get the column data types for a view?
Posted
by rally25rs
on Stack Overflow
See other posts from Stack Overflow
or by rally25rs
Published on 2010-05-04T14:52:13Z
Indexed on
2010/05/04
14:58 UTC
Read the original article
Hit count: 282
Oracle
For a table in oracle, I can query "all_tab_columns" and get table column information, like the data type, precision, whether or not the column is nullable.
In SQL Developer or TOAD, you can click on a view in the GUI and it will spit out a list of the columns that the view returns and the same set of data (data type, precision, nullable, etc).
So my question is, is there a way to query this column definition for a view, the way you can for a table? How do the GUI tools do it?
© Stack Overflow or respective owner
