Data Manipulation Language (DML)<\/span><\/b><\/p>\n Create and modify records in Salesforce by using the Data Manipulation Language, abbreviated as DML. DML provides a straightforward way to manage records by providing simple statements to insert, update, merge, delete, and restore records.<\/p>\n Each DML statement accepts either a single sObject or a list (or array) of sObjects. Operating on a list of sObjects is a more efficient way for processing records. Insert Statement : <\/b> Update Statement :<\/b> Upsert Statement : Upsert uses the sObject record’s primary key (the ID), an idLookup field, or an external ID field to determine whether it should create a new record or update an existing one:<\/p>\n Delete Statement : <\/b> Undelete Statement :<\/b> Merge Statement :<\/b> You can perform DML operations either on a single sObject, or in bulk on a list of sObjects. Performing bulk DML operations is the recommended way because it helps avoid hitting governor limits, such as the DML limit of 150 statements per Apex transaction. This limit is in place to ensure fair access to shared resources in the Lightning Platform. Performing a DML operation on a list of sObjects counts as one DML statement, not as one statement for each sObject.<\/p>\n This example inserts contacts in bulk by inserting a list of contacts in one call. The sample then updates those contacts in bulk too.<\/p>\n 1. Execute this snippet in the Developer Console using Anonymous Apex.<\/p>\n 2.\u00a0Inspect the contacts recently created in your org.<\/p>\n If a DML operation fails, it returns an exception of type DmlException. You can catch exceptions in your code to handle error conditions. Apex contains the built-in Database class, which provides methods that perform DML operations and mirror the DML statement counterparts. Unlike DML statements, Database methods have an optional allOrNone parameter that allows you to specify whether the operation should partially succeed. When this parameter is set to false, if errors occur on a partial set of records, the successful records will be committed and errors will be returned for the failed records. Also, no exceptions are thrown with the partial success option.<\/p>\n The Database methods return result objects containing success or failure information for each record. For example, insert and update operations each return an array of Database.SaveResult objects.<\/p>\n# DML Statements:
\n<\/u>The following DML statements are available.<\/span><\/h3>\n\n
\nAll those statements, except a couple, are familiar database operations. The upsert and merge statements are particular to Salesforce and can be quite handy.
\nThe upsert DML operation creates new records and updates sObject records within a single statement, using a specified field to determine the presence of existing objects, or the ID field if no field is specified.
\nThe merge statement merges up to three records of the same sObject type into one of the records, deleting the others, and re-parenting any related records.<\/p>\n# Apex DML Statements<\/u> :<\/h3>\n
\nThe insert DML operation adds one or more sObjects, such as individual accounts or contacts, to your organization\u2019s data. insert is analogous to the INSERT statement in SQL.<\/p>\nAccount newAcct = new Account(name = 'Acme');\ntry {\n insert newAcct;\n} catch (DmlException e) {\n\/\/ Process exception here\n}<\/code><\/pre>\n
\nThe update DML operation modifies one or more existing sObject records, such as individual accounts or contacts, in your organization\u2019s data. update is analogous to the UPDATE statement in SQL.<\/p>\nAccount a = new Account(Name='Acme2');\ninsert(a);\n\nAccount myAcct = [SELECT Id, Name, BillingCity FROM Account WHERE Id = :a.Id];\nmyAcct.BillingCity = 'San Francisco'; \n\ntry {\n update myAcct;\n} catch (DmlException e) {\n \/\/ Process exception here\n}<\/code><\/pre>\n
\n<\/b>If you have a list containing a mix of new and existing records, you can process insertions and updates to all records in the list by using the upsert statement. Upsert helps avoid the creation of duplicate records and can save you time as you don\u2019t have to determine which records exist first.
\nThe upsert statement matches the sObjects with existing records by comparing values of one field. If you don\u2019t specify a field when calling this statement, the upsert statement uses the sObject\u2019s ID to match the sObject with existing records in Salesforce. Alternatively, you can specify a field to use for matching. For custom objects, specify a custom field marked as external ID. For standard objects, you can specify any field that has the idLookup property set to true. For example, the Email field of Contact or User has the idLookup property set.<\/p>\nList<Account> acctList = new List<Account>();\n\/\/ Fill the accounts list with some accounts\n\ntry {\n upsert acctList;\n} catch (DmlException e) {\n \n}<\/code><\/pre>\n\n
\nThe delete DML operation deletes one or more existing sObject records, such as individual accounts or contacts, from your organization\u2019s data. delete is analogous to the delete() statement in the SOAP API.<\/p>\nAccount[] doomedAccts = [SELECT Id, Name FROM Account WHERE Name = 'DotCom']; \ntry {\n delete doomedAccts;\n} catch (DmlException e) {\n \/\/ Process exception here\n}<\/code><\/pre>\n
\nThe undelete DML operation restores one or more existing sObject records, such as individual accounts or contacts, from your organization\u2019s Recycle Bin. undelete is analogous to the UNDELETE statement in SQL.<\/p>\nAccount[] savedAccts = [SELECT Id, Name FROM Account WHERE Name = 'Universal Containers' ALL ROWS]; \ntry {\n undelete savedAccts;\n} catch (DmlException e) {\n \/\/ Process exception here\n}<\/code><\/pre>\n
\nThe merge statement merges up to three records of the same sObject type into one of the records, deleting the others, and re-parenting any related records.<\/p>\nList<Account> ls = new List<Account>{new Account(name='Acme Inc.'),new Account(name='Acme')};\ninsert ls;\nAccount masterAcct = [SELECT Id, Name FROM Account WHERE Name = 'Acme Inc.' LIMIT 1];\nAccount mergeAcct = [SELECT Id, Name FROM Account WHERE Name = 'Acme' LIMIT 1];\ntry {\n merge masterAcct mergeAcct;\n} catch (DmlException e) {\n \/\/ Process exception here\n}<\/code><\/pre>\n# Bulk DML :<\/h3>\n
\/\/ Create a list of contacts\nList<Contact> conList = new List<Contact> {\n new Contact(FirstName='Joe',LastName='Smith',Department='Finance'),\n new Contact(FirstName='Kathy',LastName='Smith',Department='Technology'),\n new Contact(FirstName='Caroline',LastName='Roth',Department='Finance'),\n new Contact(FirstName='Kim',LastName='Shain',Department='Education')};\n\/\/ Bulk insert all contacts with one DML call\ninsert conList;\n\/\/ List to hold the new contacts to update\nList<Contact> listToUpdate = new List<Contact>();\n\/\/ Iterate through the list and add a title only\n\/\/ if the department is Finance\nfor(Contact con : conList) {\n if (con.Department == 'Finance') {\n con.Title = 'Financial analyst';\n \/\/ Add updated contact sObject to the list.\n listToUpdate.add(con);\n }\n}\n\/\/ Bulk update all contacts with one DML call\nupdate listToUpdate;<\/code><\/pre>\n# DML Statement Exceptions :<\/h3>\n
\nThis example produces a DmlException because it attempts to insert an account without the required Name field. The exception is caught in the catch block.<\/p>\ntry {\n \/\/ This causes an exception because \n \/\/ the required Name field is not provided.\n Account acct = new Account();\n \/\/ Insert the account \n insert acct;\n} catch (DmlException e) {\n System.debug('A DML exception has occurred: ' +\n e.getMessage());\n}<\/code><\/pre>\n# Database Methods:<\/h3>\n
\nThese Database methods are static and are called on the class name.<\/p>\n\n
Database.SaveResult[] results = Database.insert(recordList, false);<\/code><\/pre>\nDifferences between Database Methods and DML Statements :<\/h3>\n
\n\n
\n DML Statements<\/th>\n Database Methods<\/th>\n<\/tr>\n \n You cannot get the list of success and failed records.<\/td>\n You can get the list of success and failed records as we have seen in the example.<\/td>\n<\/tr>\n \n Partial Update is not allowed. For example, if you have 100 records in list, then either all the records will be updated or none.<\/td>\n Partial update is allowed. You can specify the Parameter in Database method as true or false, true to allow the partial update and false for not allowing the same.<\/td>\n<\/tr>\n \n Example \u2212 insert accounts;<\/td>\n Example \u2212 Database.insert(listName, False), where false indicate that partial update is not allowed.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n Resources:<\/h4>\n