Category: PL/SQL

The LPAD function returns an left padded expression to a specified length with the specified characters. Lpad syntax LPAD( expression, length, [ pad_expression ] ) Lpad example select lpad(‘function’, 8) from dual; Result: function select lpad(‘function’, 8) from dual;ect chr(66) from dual; Result: fun select lpad(‘function’, 9,’0′) from dual; Result: 0function select lpad(‘function’, 10,’0′) from…(Continue Reading)

The Chr function is the opposite of the ascii function and returns the character based on the number. Chr syntax CHR ( number ) Chr example select chr(65) from dual; Result: A select chr(66) from dual; Result: B select chr(67) from dual; Result: C select chr(65)|| chr(66) || chr(67) from dual; Result: ABC select chr(97)||…(Continue Reading)

The PL/SQL EXTRACT function is a powerful tool that allows developers to extract a specific part of a date or timestamp value in Oracle databases. It is a built-in function in Oracle’s PL/SQL language and is used to retrieve individual components such as year, month, day, hour, minute, and second from a given date or…(Continue Reading)

The Sum function returns the summed value of an table column or expression. Sum syntax select sum(expression) from table; Sum 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…(Continue Reading)

The Avg function returns the average value of an table column or expression. Avg syntax select avg(expression) from table; Avg 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…(Continue Reading)