Dynamically Retrieve All fields in SOQL without Mentioning the Field Name in Salesforce

Here is the way to query the all field’s values without mentioning the Field name.

1. // Specify the Object Name to retrieve the List of field names.
2. Map<String, Schema.SObjectField> fieldMap = Account.sObjectType.getDescribe().fields.getMap();
3.        
4. String fieldName = '';
5. String accountQuery;
6.        
7. for(Schema.SObjectField currentField : fieldMap.Values())
8. {
9.      Schema.DescribeFieldResult fieldResult = currentField.getDescribe();  
10.      fieldName += fieldResult.getName() + ',';
11. }
12.        
13. fieldName = fieldName.substring(0, fieldName.length()-1);
15. // Build a Dynamic Query String.
16. accountQuery = 'SELECT ' + fieldName + ' FROM Account';
18. List<Account> accList = Database.query(accountQuery);

Reference:

Dynamic References to Schema Details Using $ObjectType

DescribeFieldResult