Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Updating one table with the data from another table with matching field

Updating one table with the data from another table with matching field

From: SKMGMT <skmgmt_at_aol.com>
Date: 1997/09/17
Message-ID: <19970917015900.VAA19564@ladder01.news.aol.com>#1/1

Kindly help with the following problem:
If there is a master table with employee info and another table called payroll consisting of 2 fields social.sec.num and salary.

Master_Table:     Name  Varchar2(20)
                          Age     Number(3)
                          Salary   Number (8)
                          Ssn      Number (10)

Payroll_Table      Ssn             Number (10)
                        Avg_Salary    Number (8)

Update the salary column of master table with avg_salary/12 for corresponding ssn. Use only SQL query. PL/SQL Block not allowed. Received on Wed Sep 17 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US