Author: Dev

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)

Oracle PL/SQL joins are a way to combine data from multiple tables into a single result set. Below are a list of pl/sql joins that you can use to learn some basic rules about joins. INNER JOIN Inner Join – The most common type of join is the inner join, which returns only rows that…(Continue Reading)

A PL/SQL query is a statement used to retrieve data from a database. A PL/SQL subquery is a query that is nested inside another PL/SQL query. The Oracle PL/SQL Query syntax typically consists of a SELECT clause, followed by a FROM clause, and optionally a WHERE, GROUP BY, and ORDER BY clause. For example: SELECT…(Continue Reading)

Oracle PL/SQL Functions Oracle PL/SQL offers a wide range of built-in functions that can be used to perform various operations on data stored in the database. Some examples of Oracle PL/SQL functions include: LENGTH returns the number of characters in a string. SUBSTR returns a specified portion of a string. INSTR returns the position of…(Continue Reading)