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
Add Two Numbers Without Arithmetic Operators in C Sharp – Add Two Numbers – Learn how to add 2 numbers without using + operator To calculate