Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SEQUENCES

Status
Not open for further replies.

oracleSQLdba

IS-IT--Management
Nov 2, 2006
53
US
How can I tell the sequences owned by my Schema?
I'm looking for the SQL statement...

Thanks
 
select owner, object_name from dba_objects
where object_type = 'SEQUENCE';

I want to be good, is that not enough?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top