db-ddlutils-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From tyju tiui <jckdnk...@yahoo.com>
Subject Re: AW: ddlutils access to sequence names
Date Mon, 17 Mar 2008 14:09:08 GMT
Ahh, Thank you Stefan. That helps.

----- Original Message ----
From: Stefan Huber <huste@vr-web.de>
To: ddlutils-user@db.apache.org
Sent: Monday, March 17, 2008 3:42:07 AM
Subject: AW: ddlutils access to sequence names


There is a system view named 'user_sequences' in the oracle database. It gives you a list
of all sequences owned by the current user.

See http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/statviews_4435.htm#i1635275
for detalis.


# Hi,
# I'm using an Oracle backend which uses sequences for auto increment.
# Is there any way I can find the names of my sequences from the db model?
# Thanks,
# Ty

Be a better friend, newshound, and 
know-it-all with Yahoo! Mobile.  Try it now.  http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message