Home » SQL & PL/SQL » SQL & PL/SQL » update query
update query [message #260872] Tue, 21 August 2007 03:03 Go to next message
Messages: 48
Registered: February 2007

i have 2 tables tab1 and tab2.tab1 is having 2 columns C1,C2 and tab2 is having 3 columns C1,C2,C3.
C1 is the key column.i want to update C2 of table2 with matching values from C2 of table 1.
tab1 is having 100 rows and tab2 is having 200 rows.all the rows in tab1 is in tab2.So it would be a kind of outer join(left).
please suggest me a update query
Re: update query [message #260880 is a reply to message #260872] Tue, 21 August 2007 03:11 Go to previous messageGo to next message
Messages: 2844
Registered: May 2007
Location: Scotland
Senior Member
Until you learn some netiquette and start replying to the people who have supplied you with answers for your past posts, I will not answer you, and I hope that no-one else will until you learn some courtesy.
Re: update query [message #260882 is a reply to message #260872] Tue, 21 August 2007 03:14 Go to previous message
Michel Cadot
Messages: 65137
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I concur.

Previous Topic: Dynamic SQL and the ORA-01489: result of string concatenation is too long
Next Topic: what tools can write select statement better?
Goto Forum:

Current Time: Thu Aug 17 08:50:37 CDT 2017

Total time taken to generate the page: 0.65486 seconds