Differentiate between Static SOQL and Dynamic SOQL in Salesforce.

Hi Pavan,

Static SOQL is one which you write in square brackets. It is good to use when you didn't have any dynamic changes in the soql query.

For example:

list<Contact> con=[Select Id, LastName from Contact]

Dynamic SOQL refers to the creation of a SOQL string at runtime with Apex code. Dynamic SOQL enables you to create more flexible applications.To create dynamic query at runtime, we use Database.query() method.

For example,

String soql = 'SELECT id, name FROM Account';

List<Account> accList = Database.query(soql);

Thanks.