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 more

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 more

Oracle 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 more

Oracle 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 more

Oracle 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