Query to find the data which not common in two tables – Learn how to select the data from table TAB1 that are not exist
Category: Oracle PL SQL
Oracle PL SQL Tutorial Examples and Queries.
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
Learn about NULL value functions like NVL, NVL2, NULLIF and COALESCE functions with simple explanation and example queries. NVL Replace NULL value with another value or
Distinct Values – Learn how to select distinct values in a table with and Without using SQL DISTINCT keyword with example queries. Below is the DUP_VALUES_TBL