Re: finding user sequences and values

From: Tom <tomNOSPAM_at_teameazyriders.com>
Date: Tue, 17 Feb 2004 22:55:01 GMT
Message-ID: <9ZwYb.1435$fV6.14562335@news-text.cableinet.net>

"Ron" <support_at_dbainfopower.com> wrote in message news:b7adnW1e9-VcBazdRVn-tw_at_comcast.com...
> Hello Tom,
>
> As Jeremy mentioned, there is no direct association.
>
> If you cannot get this information from developers, you may try to
gather
> some related information
>
> 1) By querying v$SQLTEXT for the SQL that contains sequence names
>
> 2) Checking table triggers - they may use corresponding sequences as
> well.

thanks all - managed to get the info out of user sequences got it!

thanks Received on Tue Feb 17 2004 - 16:55:01 CST