The EXISTS operator is used to correlate rows from an SELECT statement with the other one being an subquery. Course table COURSE_ID NAME DESCRIPTION DURATION PRICE 1 SQL 1 SQL course for beginners 1 week 10 2 SQL 2 SQL course for advanced 2 week 50 3 HTML5 Learn HTML 5 1 week 10 4…(Continue Reading)
Author: Dev
PL/SQL Like
The LIKE operator is used to search a string using the percent sign (‘%’) and the underscore (‘_’). Course table COURSE_ID NAME DESCRIPTION DURATION PRICE 1 SQL 1 SQL course for beginners 1 week 10 2 SQL 2 SQL course for advanced 2 week 50 3 HTML5 Learn HTML 5 1 week 10 4 PHP…(Continue Reading)
PL/SQL Between
The BETWEEN condition determines whether the value of one expression is in an interval of two other expressions. Between example COURSE_ID NAME DESCRIPTION DURATION PRICE 1 SQL 1 SQL course for beginners 1 week 10 2 SQL 2 SQL course for advanced 2 week 50 3 HTML5 Learn HTML 5 1 week 10 4 PHP…(Continue Reading)
PL/SQL Where
The WHERE clause is used to filter the results in a SELECT, INSERT, UPDATE or DELETE statement. Course table COURSE_ID NAME DESCRIPTION DURATION PRICE 1 SQL 1 SQL course for beginners 1 week 10 2 SQL 2 SQL course for advanced 2 week 50 3 HTML5 Learn HTML 5 1 week 10 4 PHP PHP…(Continue Reading)
PL/SQL Order By
The ORDER BY clause is used to order rows returned in an select statement. With ORDER BY clause you can use parameters ASC or DESC to specify ascending order and descending order. Order By example SELECT * FROM course ORDER BY price, name; SELECT * FROM course ORDER BY price ASC, name ASC; SELECT *…(Continue Reading)