Author: Viswanath A

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 

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

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

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

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

Query to find average fee of their department – Learn how to write the queries to find average fee paid by students in department wise

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

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

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