HomeНаука и техникаRelated VideosMore From: Database Star

Oracle SQL MERGE Statement

13 ratings | 402 views
https://www.databasestar.com/oracle-merge-sql/ In this video, we’ll learn what the Oracle MERGE statement does and how you can use it. What is the MERGE statement? It’s a statement that lets you either insert or update data in a table - all in a single statement! It’s helpful if you’re using an ETL (Extract Transform Load) process when creating or updating a data warehouse. It’s also helpful when loading data into your own database if you’re not creating a data warehouse. It allows you to prevent duplicate data and ensure you have up-to-date data in your table. The syntax looks like this: MERGE INTO table_name USING table_name ON (condition) WHEN MATCHED THEN update_clause DELETE where_clause WHEN NOT MATCHED THEN insert_clause [LOG ERRORS log_errors_clause reject_limit integer | unlimited ] In this video, I also show an Oracle SQL MERGE statement example, so watch the video to find out more. For more information on the MERGE statement and how you can use it in your queries, read the related article here: https://www.databasestar.com/oracle-merge-sql/
Html code for embedding videos on your blog
Text Comments (2)
Dilbag Singh (2 months ago)
please add more complicated queries after - Merge into table using (here complicated queries and not direct table) , thank you
Database Star (2 months ago)
Hi Dilbag, I have some more complicated MERGE queries available on the blog post here: https://www.databasestar.com/oracle-merge-sql/

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.