SQL WHERE clause is used to filter records and its added as below
SELECT States FROM Users where Usersgroup = ‘1’;
Breaking while loop in Java
import java.util.Scanner;
class TestingBreakWhileLoop {
public static void main(String[] args) {
int i;
Scanner input = new Scanner(System.in);
while (true) {
System.out.println(“Input an integer for this test program”);
i = input.nextInt();
if (i == 0) {
break;
}
System.out.println(“You have entered … ” + i);
}
}
}
What is SQL ORDER BY Keyword
The purpose of ORDER BY keyword is used to sort the results in descending or ascending order
e.g SELECT * FROM Users
ORDER BY State DESC;
e.g SELECT * FROM Users
ORDER BY State ASC;
or
SELECT * FROM Users
ORDER BY State;
What is difference between select and select distinct
What is the difference between select and select distinct
SELECT DISTINCT statement is used for returning only distinct (different) values from a column.
SELECT statement is used for returning all the values in the table column.
E.g SELECT States FROM Customers;
E.g SELECT DISTINCT States FROM Customers;
Summary of SQL – Please click here
String reverse using java script split method
Assume given string ‘str’ value is “welcome”
function stringRev(str) {
var splitString = str.split(“”);// Use the reverse() method to reverse the array
var arrayReverse = splitString.reverse(); // equals to [“e”, “m”, “o”, “c”, “l”, “e”, “w”]
var splitString = str.split(“”);// Use the reverse() method to reverse the array
var arrayReverse = splitString.reverse(); // equals to [“e”, “m”, “o”, “c”, “l”, “e”, “w”]
// Use join() method to join the elements of the array into a string as below in comments
var joinArray = arrayReverse .join(“”); // [“e”, “m”, “o”, “c”, “l”, “e”, “w”] to “emoclew”
//Return the reversed string
return joinArray; // “emoclew”
}
stringRev(‘welcome’);
String reverse in java script using decrementing For-loop
Assume given string ‘str’ value is “welcome”
function stringRev(str) {
var stringOne = “”;
for (var i = str.length – 1; i >= 0; i–) {
stringOne = stringOne + str[i];
}
return stringOne; // “emoclew”
}
stringRev(‘welcome’);
var stringOne = “”;
for (var i = str.length – 1; i >= 0; i–) {
stringOne = stringOne + str[i];
}
return stringOne; // “emoclew”
}
stringRev(‘welcome’);
Differences between SQL and PL/SQL
PL/SQL is procedural language where s SQL is data oriented language.
PL/SQL purpose is to create applications but SQL is data manipulator and reviewer
PL/SQL executions works at block of code level while SQL execution is per statement at a time.
PL/SQL servers for building, formatting and display application screens but SQL sources data for that screens.
PL/SQL is procedural based and instructs database on how to do but SQL is declarative level which helps database on what to do.
PL/SQL purpose it to code program blocks, procedures, triggers, functions, and packages but SQL is used to code queries, DCL, DML and DDL statements
SQL can be subset of PL/SQL but PL/SQL can not be subset of SQL
Popular databases or filesystems that uses SQL – Please click here
Defect priority and severity
Severity indicates the seriousness of the defect.
Severity types are Critical, Major, Moderate, Minor, Cosmetic
Priority indicates how quickly the defect needs to be fixed.
Priority types are High, Medium, Low.
Low Severity and Low Priority: A cosmetic error in a page which is not important to users.
High Severity and High Priority: An error in the login feature which does not allow user to login to application or a server error in the web application.
Low Severity and High Priority : The spelling mistakes that happens on the cover page or heading or title of an application.
High Severity and Low Priority: A page access error which page is rarely used by users.
Popular databases or filesystems that uses SQL
1. MySQL
2. Oracle
3. PostgreSQL
4. MS SQL Server
5. SQLite
6. Dbase
7. Hadoop
8. MaxDB
9. MariaDB
10. Openbase
What is Apex?
Apex is a programming language for salesforce (only)
-
- Object Oriented Program, in which the data types have to defined.
- Allows developers for flow execution in force.com platforms.
- Enables developers to add business logic to most system events including button clicks, related record updates and visualforce pages.
Datatypes in Apex
- Primitives
Apex primitives include the following datatypes.
- Integer
- Boolean
- Decimal
- Double
- Date
- Date Time
- Time
- String
- Long
- ID- Any valid salesforce.com Id.
- sObjects
- Any object that can be stored in force.com platform database.
- sObject variable unlike primitive variable refers to row of data in salesforce. That is a complete record as a variable.