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)
Author: Dev
PL/SQL Exists
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)
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)