Oracle SQL Tutorials – Chapter 2-3
OPERATOR PRECEDENCE Let’s list the employees which JOB_ID is SA_REP or AD_PRES , and have salary more than 15000.
Read moreOracle SQL
Oracle SQL Tutorials – Chapter 2-2
IS NULL OPERATOR Let’s list the employees that have manager. SELECT first_name,last_name, manager_id FROM hr.employees WHERE manager_id IS not NULL;
Read moreOracle SQL Tutorials – Chapter 2-1
CHAPTER 2 WHERE Conditions Comparison operators BETWEEN operator IN operator LIKE operator IS NULL operator Logical operators AND operator OR
Read moreOracle SQL Tutorials – Chapter 1-3
ARITHMETIC OPERATORS Arithmetic operations can be used on the data which type is ‘date’ or ‘number’. The priority of the
Read moreOracle SQL Tutorials – Chapter 1-2
SELECT Statement Selection : SQL statements are being used to returning the selected lines from related tables. Projection : SQL’s
Read moreOracle SQL Tutorials – Chapter 1-1
CHAPTER 1 Explaining the capabilities of the SELECT statement Writing simple SELECT statements Select columns and aliases Arithmetic operators NULL
Read more