Category: Oracle PL SQL

Parametric cursor in Oracle PL-SQL- Learn how to pass values to Explicit Parametric cursors  with OPEN statement and with for loop. Also Learn how to

Learn how to write a dynamic sql query in “for PIVOT In Clause”. Generally in “for PIVOT In Clause” only constant values are allowed as

Learn how to converts rows into columns using SQL pivot with Example queries. The PIVOT operator takes data in separate rows, aggregates it and converts

Learn how to concatenate the column wise values of a table and display the result in a single row using LISTAGG analytical function. LISTAGG function

Learn how to check the installed version of oracle Database with example queries. Below are the queries to know the release version of oracle database

Learn how to create a function based virtual column with example program. Below is the function that calculate net salary of a employee. Below is

Learn how to create a table with virtual column with Example Program. Before learning about virtual column let’s find the meaning of virtual Meaning of

Learn how to create an object type and use the object type to entire table without creating the additional columns. Also Learn how to perform

Learn how to perform DML operations(INSERT, UPDATE,DELETE,SELECT) on PLSQL objects. refer below URL for plsql object and table reference and for insertion query scripts. Example

Learn how to create an object in pl-sql with example program. A plsql object is a composite type that can be declared once and reuse