Re: view columns

From: Igor Neyman <igor.neyman_at_gmail.com>
Date: Tue, 22 Feb 2011 15:56:26 -0500
Message-ID: <AANLkTinvw_ToiNO1RefPW_bhUQk8nafmjAr=rQMQrdnq_at_mail.gmail.com>

Use the same user_tab_columns (or all/dba), specifying view_name as table_name.
It's all (tables, views) there.

Regards,
Igor Neyman

On Tue, Feb 22, 2011 at 3:48 PM, Stephens, Chris <Chris.Stephens_at_adm.com>wrote:

> Version 11.2
>
>
>
> I’m looking to write a function that returns true if two sets passed in as
> arguments are the same. A set can be a table/view/materialized view.
>
>
>
> FUNCTION fcn_ora_hash_compare(obj1 VARCHAR2, own1 VARCHAR2, obj2
> VARCHAR2, own2 VARCHAR2) RETURN BOOLEAN;
>
>
>
> Getting the column list for tables and materialized views is simple but I
> don’t see a data dictionary view that will give me that info for views.
>
>
>
> Does such a data dictionary view exist?
>
>
>
> Thanks,
>
> Chris
>
>
>
> CONFIDENTIALITY NOTICE:
> This message is intended for the use of the individual or entity to which
> it is addressed and may contain information that is privileged, confidential
> and exempt from disclosure under applicable law. If the reader of this
> message is not the intended recipient or the employee or agent responsible
> for delivering this message to the intended recipient, you are hereby
> notified that any dissemination, distribution or copying of this
> communication is strictly prohibited. If you have received this
> communication in error, please notify us immediately by email reply.
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Feb 22 2011 - 14:56:26 CST