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
Query to find the data which not common in two tables – Learn how to select the data from table TAB1 that are not exist
Query to find average fee of their department – Learn how to write the queries to find average fee paid by students in department wise
Query to select the rows that have give input value in any one of the column. Let’s say suppose you have the table naming with TEMP_TBL