We can write this query as an example given follows
Update(Select location loc, city city from Employee emp, Address addr where emp.empid = addr.empId and emp.location is null) SET loc = city
Subscribe to:
Post Comments (Atom)
skip to main |
skip to sidebar
Joins are very important in Oracle. You can update table with the help of the JOINS. The syntax for the JOINS easy to understand but the exact concept is bit difficult to learn. I am still not familiar with JOINS. I want you to explain it with the help of table.
ReplyDeletesap erp training