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
prashanthgs
Messages: 89
Registered: May 2005
Location: chennai
Member
Hi

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,
Prashanth
Re: Update Statement [message #347672 is a reply to message #347671] Fri, 12 September 2008 11:30 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
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
dwarak.k
Messages: 61
Registered: June 2008
Location: Hyderabad
Member
Read this & Try
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_10007.htm#SQLRF01708

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


Current Time: Sat Dec 03 01:36:16 CST 2016

Total time taken to generate the page: 0.11674 seconds