Category: Oracle PL SQL

Query to find the data which not common in two tables – Learn how to select the data from  table TAB1 that are not exist

Learn how to transpose columns to rows using oracle UNPIVOT clasuse UNPIVOT clause allows transpose columns to rows. UNPIVOT is purely opposite to PIVOT clause

Cursor attributes in Oracle – Learn about Cursor attribute types related PL-SQL Implicit Cursor and also Learn how to use the attributes with Examples. Cursor

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

CTE – Learn how to use a temporary query  using with Clause for referencing the select , insert, update, delete statements. CTE CTE stands for

SQL DUAL Table – Learn when to use dual table in SQL with example queries. DUAL DUAL is a dummy table that is automatically created

IN ANY SOME ALL operators in PL-SQL – Learn about in, Any, Some, All operators usage in PL-SQL  with example Programs. Let’s Create a Student

Decode function vs Case statement in PL-SQL  – Learn how to use Decode function and Case statements in the situations where you need to use 

Difference between Procedure and Function – Learn how to create a procedure and function with example Programs and also learn basic difference between procedure and