Table of Contents
Introduction
If we want to save records in the database on a permanent basis, we use DML statements in salesforce. We have multiple DML statements through which we can insert, update, delete or undelete records in the Salesforce database.
Some are mentioned below:
1. Insert
2. Delete
3. Update
4. Undelete
INSERT Operation
It is used to insert new records into any object. In this, row identification is not required due to the insertion of records.
Syntax
DMLStatement sObjectName;
Insert sObjectName;
Example
Here I want to insert Account record with Account name as ‘New Account’ and Industry as chemical.
Account acc = new Account();
acc.Name = ‘New Account’;
acc.Industry = ‘Chemicals’;
insert acc;
UPDATE Operation
It is used to modify the existing data or records. Row identification is required since we are updating the records. So, we need to identify which record to update.
Syntax
Update sObjectName;
Example
Update the type to ‘prospect’ and Industry as ‘Banking’ of the Account object.
acc.type = ‘Prospect’;
acc.Industry = ‘Banking’;
update acc;
DELETE Operation
It is used to delete the existing records present in our salesforce org.
Once the record is deleted, it will go to recycle bin for 15 days. Within 15 days, we can restore our records, after that, they will be no more present in our org.
Syntax
delete sObjectName;
Example
delete acc;
The record will be deleted and stored in the recycle bin.
0 Comments