OraFAQ Forum: Training & Certification » Hoy to update a column of table A with data from column of table B?

Home » Other » Training & Certification » Hoy to update a column of table A with data from column of table B?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Hoy to update a column of table A with data from column of table B? [message #259352]

Wed, 15 August 2007 03:22

atgl
Messages: 25
Registered: March 2006

Junior Member

Hi,

I want to update column A of table 1 with data from column B of table 2 where connection of both table is via primary key of both table 1 & 2.

Sample Table 1

Columm C1    Column A
1           Jack
2           Mary

Sample Table 2

Columm C2    Column B
1           Jack J. Mole
2           Mary Kit

At the end of the day, my table 1 should look like below:-

Column C1    Column A
1            Jack J. Mole
2            Mary Kit

Table 2 is just a temp table. And I am using Oracle 8i.

Report message to a moderator

Re: Hoy to update a column of table A with data from column of table B? [message #259357 is a reply to message #259352]

Wed, 15 August 2007 03:49

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Just use a join.
Tell us what you already try and where you are stuck.

Regards
Michel

Report message to a moderator

Previous Topic:	Packages
Next Topic:	What is "pragma autonomous transaction"? (renamed by LF)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 12 14:52:19 CDT 2026