db-ddlutils-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stefan Huber <hu...@vr-web.de>
Subject AW: ddlutils access to sequence names
Date Mon, 17 Mar 2008 07:42:07 GMT
Hi,

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.

Stefan 


# 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

Mime
View raw message