DML Query

Professional

DML stands for Data Manipulation Language. This is a core feature of typical RDBMS systems. However, Salesforce doesn't provide this capability. Hence, Brobench implements these queries as part of its SOQL enhancements.

For example, you can run below query to update records based on certain conditions. Brobench will do all the heavy lifting like fetching the matching records, preparing the new set of records to be updated and then update Salesforce with new records.

update account set billingstreet = shippingstreet
where billingstreet = null

DML Query consist of three type of queries as shown below. See those pages for more information about each of those queries.

• DML Update
• DML Delete
• DML Undelete