Question

g Write an UPDATE statement that changes the address for the row with vendor_id 4 so the suite number (Ste 260) is stored in vendor address instead of vendor address 1. Then, use SQL Developer to verify the change (you may need to click the Refresh button at the top of the Data tab to see the change). If this works correctly, go back to the tab for the UPDATE statement and click the Commit button to commit the change.

Answer 1

UPDATE 'Vendors' SET 'address' = 'Ste 260' WHERE 'vendor_id' = 4

Step-by-step explanation:

Required

Write an update statement

The question is incomplete as the table name is not given.

So, I will make the following assumptions.

Table name = Vendors

So, the update statement is:

UPDATE 'Vendors' SET 'address' = 'Ste 260' WHERE 'vendor_id' = 4;

The above statement queries the vendors table and changes the address of vendor_id 4 from the initial value to Ste 260