DML statements
We use these statements if a company wants to control the inserts and updates of accounts through a complex process, and also wants to compare the data to an external data source. Plenty of companies have this (at first sight) simple requirement. During this process, we will insert and/or update records with new field information, received from the external data source.
What about the deletion of old data? Does it happen through an automated process, or do we need to archive the data and delete it afterward? For all these requirements, we need to use a language that can modify our data. You need to insert, update, delete, and/or merge data to display this data to your users and keep the data up to date.
As a developer, you ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access