Oracle SQL Tutorials Chapter 7 ( Part 2 of 2 )

CREATING TABLE WITH SUB-QUERIES With this method, table is created automatically with the column types that result from a query.

Read more

Oracle SQL Tutorials Chapter 7 ( Part 1 of 2 )

Chapter 7 – CREATING AND MANAGING TABLES Classify Main Database Objects Examining Table Structure Data Types of the Columns Creating

Read more

Oracle SQL Tutorials

Hi, I’m writing Oracle SQL articles and sharing with you. You can learn SQL by following my articles and trying

Read more

Oracle SQL Tutorials – Chapter 5

Chapter 5 – Selecting Data From Multiple Tables Usage of multiple tables in one query Combining tables – JOIN Different

Read more

Oracle SQL Tutorials – Chapter 4

Chapter 4 – Group Functions AVG Function SUM Function MIN Function MAX Function COUNT Function DISTINCT Function GROUP BY Statement

Read more

Oracle SQL Tutorials – Chapter 3 (Part 3 of 3)

CONVERSION FUNCTIONS TO_CHAR (DATE) TO_CHAR(date, ‘format’) It’s case-sensitive and must be written between quotes. It must contain a valid date

Read more

Oracle SQL Tutorials – Chapter 3 (Part 2 of 3)

NUMERIC FUNCTIONS ROUND Let’s try some different usages of the ROUND function. SELECT ROUND (45.923), ROUND (45.943, 1), ROUND (45.924,

Read more

Oracle SQL Tutorials – Chapter 3 (Part 1 of 3)

Chapter 3 – Single Row Functions Charcter Functions Numeric Functions Date Functions Converting Functions NVL Function Decode Function CASE Statement

Read more

Oracle SQL Tutorials – Chapter 2 (Part 3 of 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 (Part 2 of 3)

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