Oracle sql updating multiple tables

posted by | Leave a comment

HINT: CTRL Enter will execute the single statement your cursor is on.Hi, I have to update multiple tables at a time like update emp e,dept d set e.ename='xyz',d.dname='abc' where e.deptno=d.deptno and e.empno=4567 and d.deptno = 10 it is giving error.Along with 16 years of hands on experience he holds a Masters of Science degree and a number of database certifications.For any SQL Server Performance Tuning Issue send email at [email protected]

Each of these tables contain fields you can combine in a single Pivot Table to slice your data in multiple ways.Pinal is also a Cross Fit Level 1 Trainer (CF-L1) and Cross Fit Level 2 Trainer (CF-L2).You can also insert data using the 'traditional' method you'd use when using a command line or SQL Plus.However, the easiest and the most clean way is to use JOIN clause in the UPDATE statement and use multiple tables in the UPDATE statement and do the task.As you can see that using JOIN clause in UPDATE statement it makes it very easy to update data in one table from another table.

Leave a Reply

Free online hot sex chat sighs