Lesson: 03 | DML Statements | Update

Notes

Use the following code to update all the existing records of the Account Object:

List<Account> AccountList = [SELECT id, name FROM Account];

for(Account singleAccount: AccountList){
    singleAccount.AnnualRevenue = 500000;
    singleAccount.YearStarted ='2045';
}

update AccountList;

Use the following code to update the Account Number field of the Account object if account number is empty (Null).

List<Account> AccountList = [SELECT id, name FROM Account WHERE AccountNumber=Null];

for(Account singleAccount: AccountList){
    singleAccount.AccountNumber = 'ACCOUNTNUMBER';
}

update AccountList;

System.debug(AccountList.size());

Exercises

#	Exercise
1	Bulk Update Account Ratings

Prev You need to login to have access to the quizzes. Next

Mastered by 75 users.

Apex Intermediate

A. Apex DML Operations (8 lessons)

B. Apex Classes (17 lessons)

C. Apex Triggers (9 lessons)

D. Apex Exceptions (11 lessons)

E. Asynchronous Apex (6 lessons)

F. SOSL (10 lessons)

G. Testing Apex (9 lessons)

H. Apex Fast Recap (142 lessons)

I. Build Apex Coding Skills (64 lessons)

You need to complete all the quizzes before certification.

Go to top

Login to your account

Lesson: 03 | DML Statements | Update

Notes

Apex Intermediate