Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Updating one table with the data from another table with matching field
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
![]() |
![]() |