Home » SQL & PL/SQL » SQL & PL/SQL » about sequence (9i)
about sequence [message #298682] Thu, 07 February 2008 02:46 Go to next message
Messages: 9
Registered: February 2008
Location: hyderabad
Junior Member

How can we have sequence in decremental order of values...
I know about creating sequence like (1,2,3..)

Excuse me if you don't feel comfortable with the above sentence.
Re: about sequence [message #298683 is a reply to message #298682] Thu, 07 February 2008 02:47 Go to previous message
Messages: 2818
Registered: May 2007
Location: Scotland
Senior Member
Set a negative value for increment by.
Previous Topic: Need help about ORA-01427: single-row subquery returns more than one row
Next Topic: can we use procedure on select command
Goto Forum:

Current Time: Thu Oct 27 04:47:34 CDT 2016

Total time taken to generate the page: 0.11585 seconds