Home » SQL & PL/SQL » SQL & PL/SQL » Displaying a created SEQUENCE
Displaying a created SEQUENCE [message #7172] Mon, 26 May 2003 06:34
Newbie Ryan
Messages: 1
Registered: May 2003
Junior Member
I created the following SEQUENCE.
CREATE SEQUENCE ID_NO INCREMENT BY 1
START WITH 1
MAXVALUE 1000;

I have created a table with mixed ID_NO not in any order. How can I call and display the SEQUENCE to arrange the data the SEQUENCE data.

I know how to used SELECT and ORDER BY, but is there a way to call the SEQUENCE to display.

Thank you very much.

Report message to a moderator

Previous Topic: how to use os command in pl/sql programme
Next Topic: How to find missing no in a sequence
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 22:27:56 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.