Home » SQL & PL/SQL » SQL & PL/SQL » Update Statement (Oracle 10g)
Update Statement [message #347671] Fri, 12 September 2008 11:28 Go to next message
Messages: 89
Registered: May 2005
Location: chennai

I have a table PRODUCT with field,

product id as 100, productname visa and productno as 200.

I need to update the value of productno with value of productid.

ie, 200 to 100

I am having more than 2000 records. can u pls provide me the update statement on this..

update product set productno=productid;

Thanks and Regards,
Re: Update Statement [message #347672 is a reply to message #347671] Fri, 12 September 2008 11:30 Go to previous messageGo to next message
Messages: 24958
Registered: January 2009
Location: SoCal
Senior Member
Please read & follow posting guidelines as stated in URL above
Re: Update Statement [message #347675 is a reply to message #347671] Fri, 12 September 2008 11:50 Go to previous message
Messages: 61
Registered: June 2008
Location: Hyderabad
Read this & Try

Previous Topic: Insert multiple records into a table
Next Topic: Union question
Goto Forum:

Current Time: Fri Oct 21 23:20:00 CDT 2016

Total time taken to generate the page: 0.08508 seconds