Home » SQL & PL/SQL » SQL & PL/SQL » How i do a sequence?
How i do a sequence? [message #37359] Fri, 01 February 2002 14:20 Go to next message
Gladys
Messages: 4
Registered: February 2002
Junior Member
Hi,

Please tell me the code that i can write in Oracle througt which i can get made the sequence:

Example:

p108 1 1
p108 1 2
p108 1 3
p209 2 1
p209 2 2
p323 3 1
p454 4 1
p454 4 2

Thanks,

Report message to a moderator

Re: How i do a sequence? [message #37360 is a reply to message #37359] Fri, 01 February 2002 17:56 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
do u mean sorting?

select col1,col2,col3 from tab1 order by 1,2,3

or

select col1,col2,col3 from tab1 order by col1,col2,col3

Report message to a moderator

Previous Topic: CREATING A NEW SCHEMA?
Next Topic: sql*net
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 23 23:30:01 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.