Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: user_part_tables
SQL> create table t (d date) ;
Table créée.
SQL> create view v (birthday) as select d from t ;
Vue créée.
SQL> describe v
Nom NULL ? Type ----------------------------------------------------- -------- ------------------------- BIRTHDAY DATE
SQL> select text from user_views where view_name = 'V' ; TEXT
SQL>
-----Original Message-----
Bill Coulam
This question probably applies to other data dictionary views as well.
...
Ordinarily, if a view has a column named "PARTITIONING_TYPE", I expect to find, in the view's source, a column or alias that reads "partitioning_type". Instead, I see unnamed derived columns, and named columns, that seem to be magically transformed to different names that show up in user_part_tables.
Which brings me to my question: What makes the magical column name transformation happen? What piece of this puzzle am I missing?
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Apr 27 2005 - 20:38:56 CDT