Category: PL/SQL

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)

The PL/SQL FULL JOIN returns all rows from left table and right table even if the condition is not fulfilled. Phones table PHONE_ID PHONE_NAME 1 Galaxy Note Edge 2 N910 Galaxy Note 4 3 Galaxy S5 Duos 4G 4 iPhone 5S 5 iPhone 6 Plus 6 930 Lumia 7 830 Lumia Phone_orders table ORDER_ID PHONE_ID…(Continue Reading)

The PL/SQL SELF JOIN is joining a table to itself and returns rows when there is at least one match in the tables. Phones table PHONE_ID PHONE_NAME BRAND_ID 1 Galaxy Note Edge 1 2 N910 Galaxy Note 4 1 3 Galaxy S5 Duos 4G 1 4 iPhone 5S 2 5 iPhone 6 Plus 2 6…(Continue Reading)