Home » RDBMS Server » Server Administration » How to find all the sequences I have created?
How to find all the sequences I have created? [message #370152] Sat, 23 December 2000 00:35 Go to next message
wyshuai
Messages: 13
Registered: December 2000
Junior Member
I once created several sequences , and now I have forgotten the name of the sequences. Can you tell me how ?

Report message to a moderator

Re: How to find all the sequences I have created? [message #370154 is a reply to message #370152] Mon, 25 December 2000 22:30 Go to previous message
P. Lavanya
Messages: 8
Registered: November 2000
Junior Member
Hi,

Give this at SQL prompt.

SELECT OBJECT_NAME
FROM ALL_OBJECTS
WHERE OBJECT_TYPE = 'SEQUENCE'
AND OWNER = '< enter the name under which you created these sequences> '

Hope this helps.
bye,
lavP

Report message to a moderator

Previous Topic: Query With 'Like' Option
Next Topic: How to use sql*plus to interactive with user?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 17 09:04:22 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.