Re: duplicate view

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Wed, 08 Dec 2004 10:53:00 +1100
Message-ID: <41b6425b$0$12876$afc38c87@news.optusnet.com.au>

db2group88_at_yahoo.com wrote:
> we are using oracle 10g. Our application required to duplicate a view
> from existing view during run time, which means the only difference is
> different view name and different table name, but the definition is the
> same. in order to do that, i would like to retrieve the catalog info
> about the view. Do you know which view under sys schema provide that
> info?
>

select * from dba_views;

HJR Received on Tue Dec 07 2004 - 17:53:00 CST