View Related Help [message #397791] |
Mon, 13 April 2009 23:25  |
sr_orcl
Messages: 82 Registered: January 2009 Location: mumbai
|
Member |

|
|
Hi,
I have to add comment to View.But Name Of column is rename with different column name .So that I cant compare view columns with base table columns.Can you please tell me in which data dictionary table all the views columns are stored.
|
|
|
|
|
|
Re: View Related Help [message #397835 is a reply to message #397797] |
Tue, 14 April 2009 02:34   |
JRowbottom
Messages: 5933 Registered: June 2006 Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
As far as I know, this is going to be a purely manual process.
Assuming that you've got the SQL that you created the view from, then it shouldn't be too hard.
|
|
|
|
|
Re: View Related Help [message #398070 is a reply to message #398033] |
Wed, 15 April 2009 02:24   |
JRowbottom
Messages: 5933 Registered: June 2006 Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
What comments?
You can't create Comments on view columns - only on tables, columns, operators, indextypes and materialized views.
I think you need to explain what, exactly, you're trying to achieve - your one and 2 line drip feed explanations are only confusing things.
|
|
|
|
|
|
|