Refresh query on multiple tables

Question

I have a circuit like:

• employees (eno, ename, zip, hdate)
• customers (cno, cnmae, street, zip code, phone)
• zipcodes (zip, city)

where zip is pk in zipcodes and fk in other tables.
I have to write an update request that updates the entire origin of zipcode 4994 to 1234 across the entire database.

update zipcodes,customers,employees  
  set zip = 0  
where customers.zip = zipcodes.zip 
  and employees.zip = zipcodes.zip;  

but I know that I am not doing it right. Is there a way to update all zip tables in a single update request?

Answer 1

Oracle does not support instructions for updating multiple tables.

• Confirm that zipcode "1234" exists in the table ZIPCODES

  INSERT INTO ZIPCODES 
    (zip, city)
  VALUES
    (1234, '?')
  

• CUSTOMERS EMPLOYEES:

  UPDATE CUSTOMERS
     SET zip = 1234
   WHERE zip = 4994
  
  UPDATE EMPLOYEES
     SET zip = 1234
   WHERE zip = 4994
  

• :

  DELETE FROM ZIPCODES
   WHERE zip = 4994
  

Answer 2

. .

NEW THOUGHT:. , 1 , .

Answer 3

, zip zipcode, zip , , zipcode.

Answer 4

, : SQL . , , Oracle . , , , . , , - .

; , . , , " ", zipcode, .

: Oracle:( .

Answer 5

Use a stored procedure. There you can perform this operation on multiple tables using conditional statements.

Answer 6

This may lead to your problem. And you can update or delete in the for loop database for values

Begin
for Zip_value in 1234.. 4559 loop
update zipcodes
  set zip = 0   
where customers.zip = zipcodes.zip  
  and employees.zip = zipcodes.zip;
  and zipcodes.zip = Zip_value;
update customers
  set zip = 0   
where customers.zip = zipcodes.zip  
  and employees.zip = zipcodes.zip;
  and zipcodes.zip = Zip_value;
update employees   
  set zip = 0   
where customers.zip = zipcodes.zip  
  and employees.zip = zipcodes.zip;
  and zipcodes.zip = Zip_value;
  END LOOP;
commit;
end;
/