Update - Post.Byes

X

montyyogeshpatel

New Member

Join Date: Sep 2008

Posts: 4
#1

Update

Sep 13 '08, 04:02 AM

hi friends my Q is that if i want to update serial no. of any table in increasing order how i can update .

pls tell me............. .........
Tags: None
debasisdas

Recognized Expert Expert

Join Date: Dec 2006

Posts: 8119
#2

Sep 13 '08, 05:06 AM

you need to use a SEQUENCE for the purpose.
Comment
montyyogeshpatel

New Member

Join Date: Sep 2008

Posts: 4
#3

Sep 13 '08, 05:49 AM

how i can use SEQUENCE pls tell me in detail
Comment
debasisdas

Recognized Expert Expert

Join Date: Dec 2006

Posts: 8119
#4

Sep 13 '08, 02:01 PM

you need to use a cursor to take all the column values and then update one after another in a loop from the value generated by the cursor.
Comment
amitpatel66

Recognized Expert Top Contributor

Join Date: Mar 2007

Posts: 2358
#5

Sep 15 '08, 09:25 AM

Originally posted by montyyogeshpate l

how i can use SEQUENCE pls tell me in detail

Check here for oracle sequence
Comment

Previous template Next

Working...