The PL/SQL RIGHT JOIN return all rows from the right table, although there are no matches in the left table. Phones table PHONE_ID PHONE_NAME BRAND_ID 1 Galaxy Note Edge 1 2 N910 Galaxy Note 4 1 3 Galaxy S5 Duos 4G 1 4 iPhone 5S 2 5 iPhone 6 Plus 2 6 930 Lumia 3…(Continue Reading)
Author: Dev
PL/SQL Left Join
The PL/SQL LEFT JOIN return all rows from the left table, although there are no matches in the right table. Phones table PHONE_ID PHONE_NAME BRAND_ID 1 Galaxy Note Edge 1 2 N910 Galaxy Note 4 1 3 Galaxy S5 Duos 4G 1 4 iPhone 5S 2 5 iPhone 6 Plus 2 6 930 Lumia 3…(Continue Reading)
PL/SQL Inner Join
The PL/SQL INNER JOIN return rows when there is at least one match in the tables. Phones table PHONE_ID PHONE_NAME BRAND_ID 1 Galaxy Note Edge 1 2 N910 Galaxy Note 4 1 3 Galaxy S5 Duos 4G 1 4 iPhone 5S 2 5 iPhone 6 Plus 2 6 930 Lumia 3 7 830 Lumia 3…(Continue Reading)
PL/SQL ANY
The PL/SQL ANY is used like comparison condition, must be preceded by =, !=, >, < , = and followed by a list or subquery. ANY example SELECT * FROM course WHERE price = ANY (10,20); Output COURSE_ID NAME DESCRIPTION DURATION PRICE 1 SQL 1 SQL course for beginners 1 week 10 3 HTML5 Learn…(Continue Reading)
PL/SQL IN
The PL/SQL IN operator is used to compare a term of a condition with a list of fixed values. IN example SELECT * FROM course WHERE price IN (10,20); Output COURSE_ID NAME DESCRIPTION DURATION PRICE 1 SQL 1 SQL course for beginners 1 week 10 3 HTML5 Learn HTML 5 1 week 10 5 CSS…(Continue Reading)