Re: Which table holds the view cols?

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Fri, 15 Nov 2002 21:04:31 +0100
Message-ID: <tpkatuol27kv7qj6noo2heip6rnuflrahp_at_4ax.com>

[Quoted] [Quoted] On Fri, 15 Nov 2002 10:24:25 -0800, Praveen <p-nospam-mohanan_at_directvinternet.com> wrote:

>Hi..All,
>
> When a user creates a table, all_tab_columns/user_tab_columns holds the
>list of columns. When we create view, the all_views table hold only the text of
>the view when it was generated. Which table holds the name of the columns of the
>view?
>
>TIA
>
>P/

[Quoted] There simply is no such view.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Nov 15 2002 - 21:04:31 CET

This message: [ Message body ]
Next message: Sybrand Bakker: "Re: How to create a trace file for TKPROF"
Previous message: Tony Garrido: "How to create a trace file for TKPROF"
In reply to Praveen: "Which table holds the view cols?"
Next in thread: Frank Diedrich: "Re: Which table holds the view cols?"
Reply: Martin Doherty: "Re: Which table holds the view cols?"
Reply: Karsten Farrell: "Re: Which table holds the view cols?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message