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
Delete Truncate and Drop -Learn basic differences between Delete Truncate and Drop commands with examples. DELETE TRUNCATE DROP DML command DDL command DDL command Need
SQL Merge statement – Learn how to insert, delete and update the records into the table using single statement. MERGE-statement made for situations when you want
Oracle Unique constraint vs Unique Index- Learn about unique constraint and unique index creation and their difference with example programs. For brief discussion about unique
Subtract 2 numbers without using arithmetic operators – Learn how to subtract 1 from a given input number and also learn how to subtract 2
Given an array of N integers.Find the contiguous sub array with Maximum sum. Contiguous sub array means sub-array with sequence index like (0,1,2..) or(1,2,3…) INPUTN:Size
Instead of Triggers -Learn how when to use instead of Triggers with programming Example. When you are not allowed modify a view directly then you
Complex Views – Learn how to create complex views , when can we update views and when we cannot update views with example Programs. Complex