Home » RDBMS Server » Server Administration » Return Multiple Sequence Numbers
Return Multiple Sequence Numbers [message #54373] Wed, 13 November 2002 18:44 Go to next message
pb
Messages: 18
Registered: December 2000
Junior Member
I want to execute a SQL statement that would return the next three sequence numbers from a sequence. How do I phrase the sql statement?

Report message to a moderator

Re: Return Multiple Sequence Numbers [message #54401 is a reply to message #54373] Fri, 15 November 2002 03:18 Go to previous message
puneet
Messages: 76
Registered: August 2002
Member
heres one way .....
create sequence temp1 increment by 3;
select temp1.nextval,temp1.nextval + 1,temp1.nextval +2 from dual;

try it out .... hope this meets your requirement

Report message to a moderator

Previous Topic: Re: download free ocp dumps,papers,ocp kits...
Next Topic: Error Starting Database.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 01:54:54 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.