Category: PL/SQL

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)

In this page we have a list of PL/SQL Data Manipulation Language (DML) statements that you can use as a small introduction to dml statements. DML or Data Manipulation Language statements are used to manipulate data in a database. There are four types of DML statements: INSERT, UPDATE, DELETE, and MERGE. INSERT statement is used…(Continue Reading)