Home » SQL & PL/SQL » SQL & PL/SQL » how to update column value with out using sequences (oracle 11g)
how to update column value with out using sequences [message #582337] Wed, 17 April 2013 04:55 Go to next message
mkrish111
Messages: 4
Registered: April 2013
Location: HYDERABAD
Junior Member
HI All,

I am having a table with out a primary key .It also contains data.

My requirement is to add a new column to the table and update the column value with unique and sequential number , starting from 1 to end of rows.

This has to be done with out using a sequence.

Thanks
krish.
Re: how to update column value with out using sequences [message #582338 is a reply to message #582337] Wed, 17 April 2013 05:20 Go to previous messageGo to next message
Littlefoot
Messages: 19541
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This seems to be a popular homework these days, eh?
Re: how to update column value with out using sequences [message #582340 is a reply to message #582338] Wed, 17 April 2013 05:28 Go to previous message
Michel Cadot
Messages: 58959
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Same IP. same guy or same class.

Regards
Michel
Previous Topic: How to use Row Generator
Next Topic: Functions within a Package
Goto Forum:
  


Current Time: Wed Sep 03 01:24:23 CDT 2014

Total time taken to generate the page: 0.11036 seconds