Pl sql updating tables from another table

29-Apr-2018 02:19

SQLERRM); end; Update ( select parent_parent_key, child_child_key, parent_table.value parent_value, child_table.value child_value from parent_table join child_table on child_= parent_table.key) set child_value = parent_value; This will be faster and more robust than a PL/SQL cursor-based method.

Incidentally, you can also delete child records using a similar technique of deleting against a key-preserved view.

1) It runs forever because there is no EXIT from your loop.

Lead ID) WHERE Sales_Import.leadid = (SELECT Retrieve Account Number.

Both the databases have the same structure, but different data.

Database1 (Test1) is the latest, and database2 (Test2) is an old copy of the database.

Of course this does not answer the question of why you'd want to place a parent attribute in a child table.

UPDATE summary_data SET current_category = (SELECT category_id FROM products WHERE products.product_id = summary_data.product_id) WHERE EXISTS (SELECT category_id FROM products WHERE products.product_id = summary_data.product_id); If you want to test your skills using the SQL UPDATE statement, try some of our practice exercises.

Lead ID) WHERE Sales_Import.leadid = (SELECT Retrieve Account Number.

Both the databases have the same structure, but different data.

Database1 (Test1) is the latest, and database2 (Test2) is an old copy of the database.

Of course this does not answer the question of why you'd want to place a parent attribute in a child table.

UPDATE summary_data SET current_category = (SELECT category_id FROM products WHERE products.product_id = summary_data.product_id) WHERE EXISTS (SELECT category_id FROM products WHERE products.product_id = summary_data.product_id); If you want to test your skills using the SQL UPDATE statement, try some of our practice exercises.

Content Wrapper:after.hidden.normal.grid_page.grid_page:before,.grid_page:after.grid_page:after.grid_page h3.grid_page h3 a.grid_page h3 a:hover.grid_page h3 a.action_button.grid_page h3 a.action_button:active.grid_page h3 a.action_button:hover.grid_page h3 a.action_button:not(.fake_disabled):hover.grid_page h3 a.action_button:not(.fake_disabled):focus.grid_pagediv.