Home » SQL & PL/SQL » SQL & PL/SQL » can i create sequence for the existing records in the table
can i create sequence for the existing records in the table [message #190469] Wed, 30 August 2006 23:35 Go to next message
srikanth.fmr
Messages: 1
Registered: August 2006
Junior Member
hii all

can we create a sequence for the records tht are already existing in the table.
if yes how?

cheers
icon2.gif  Re: can i create sequence for the existing records in the table [message #190486 is a reply to message #190469] Thu, 31 August 2006 00:42 Go to previous messageGo to next message
amul
Messages: 252
Registered: April 2001
Location: Chennai
Senior Member
you can create a sequence for the future records but not existing records.
Re: can i create sequence for the existing records in the table [message #190573 is a reply to message #190469] Thu, 31 August 2006 05:12 Go to previous message
hobbes
Messages: 173
Registered: January 2006
Senior Member
Quote:

can we create a sequence for the records tht are already existing in the table

Can you explain a bit more: do you want to add a new column to a table, and put in sequence-generated identifiers for existing records? Or are you looking for something else?
Previous Topic: rename duplicate records
Next Topic: CAST and MULTICAST
Goto Forum:
  


Current Time: Thu Dec 08 16:20:09 CST 2016

Total time taken to generate the page: 0.16159 seconds