Author: Dev

  The Min function returns the minimum value of an expression. Min syntax select min(expression) from table; Min 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 PHP…(Continue Reading)

The Max function returns the maximum value of an expression. Max syntax select max(expression) from table; Max 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 PHP course…(Continue Reading)

The COUNT function returns the number of rows returned by the query. Count syntax COUNT( expression ) Count example STUDENT_ID FIRST_NAME LAST_NAME CITY 1 Daniel SCOTT New York 2 Anthony SIMMONS Chicago 3 Sophia THOMPSON Los Angeles select count(*) from students; Result: 3

The LENGTH function returns the length of string. Length syntax LENGTH( string ) Length example select length(”) from dual; Result: (null) select length(NULL) from dual; Result: (null) select length(12345) from dual; Result: 5 select length(‘12345’) from dual; Result: 5 select length(‘12,345.89’) from dual; Result: 9 select length(‘Reference’) from dual; Result: 9 select length(‘PL/SQL Reference’) from…(Continue Reading)

The CONCAT function returns string1 concatenated with string2. Concat syntax CONCAT( string1, string2 ) Concat example select concat(‘ab’, ‘c’) from dual; Result: abc select concat(‘123′, ’45’) from dual; Result: 12345 select concat(‘PL/SQL’, ‘ Reference’) from dual; Result: PL/SQL Reference Concat example STUDENT_ID FIRST_NAME LAST_NAME CITY 1 Daniel SCOTT New York 2 Anthony SIMMONS Chicago 3…(Continue Reading)