Updating a table from another table in oracle

However the script above gives the following output : drop table t succeeded.

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.

These exercises allow you to try out your skills with the UPDATE statement.

You will be given questions that you need to solve.

The table holds comments on data items, where the data is held in datasets.

First of all you must test it, use your development DB and test with 10000 rows, 100000 rows, or yours 2500000 rows, and estimate the time needed to complete the task.That information, along with your comments, will be governed by DISQUS’ privacy policy.By commenting, you are accepting the DISQUS terms of service.Product table for all rows that have an existing value of 'Red' in the Color column and have a value in the Name column that starts with 'Road'.Anyway -- my suggestion -- lose the procedural code.

Leave a Reply