OraFAQ Forum: SQL & PL/SQL » Sequence creation

Home » SQL & PL/SQL » SQL & PL/SQL » Sequence creation (Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Sequence creation [message #575648]

Fri, 25 January 2013 03:19

saipradyumn
Messages: 131
Registered: October 2011
Location: Hyderabad

Senior Member

Hi all ,

How to create the sequence which gives following values
1
0
1
0
1
0
when we excite the following query , it has to give the above results
select seq.nextval from dual

Thanks
SaiPradyumn

Report message to a moderator

Re: Sequence creation [message #575654 is a reply to message #575648]

Fri, 25 January 2013 04:11

sss111ind
Messages: 268
Registered: April 2012
Location: India

Senior Member

CREATE SEQUENCE test_seq INCREMENT BY 1 START WITH 1 MINVALUE 0 MAXVALUE 1 CYCLE NOCACHE;

Report message to a moderator

Re: Sequence creation [message #575656 is a reply to message #575654]

Fri, 25 January 2013 04:36

Michel Cadot
Messages: 54155
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Why NOCACHE?
Let CACHE unless you have a very good reason to use NOCACHE.

Regards
Michel

Report message to a moderator

Re: Sequence creation [message #575664 is a reply to message #575656]

Fri, 25 January 2013 04:58

saipradyumn
Messages: 131
Registered: October 2011
Location: Hyderabad

Senior Member

Thanks

Report message to a moderator

Re: Sequence creation [message #575665 is a reply to message #575656]

Fri, 25 January 2013 05:01

sgollapudi
Messages: 9
Registered: January 2013
Location: HYDERABAD

Junior Member

Another way...

CREATE SEQUENCE test_seq INCREMENT BY -1 START WITH 1 MINVALUE 0 MAXVALUE 1 CYCLE NOCACHE;

Michael, We can not cache for the above sequence creation.

Report message to a moderator

Re: Sequence creation [message #575668 is a reply to message #575665]

Fri, 25 January 2013 05:43

Michel Cadot
Messages: 54155
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Maybe one of the good reasons.

Regards
Michel

Report message to a moderator

Previous Topic:	forall update with bulk collect for multiple columns
Next Topic:	Using Nested Table (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 20 23:10:19 CDT 2013

Total time taken to generate the page: 0.35170 seconds