Category: Oracle PL SQL

Learn how to find a sub string from the main string using oracle SUBSTR function The SUBSTR() function returns a substring from the str starting

Learn how to find the position of a sub string from the main string with oracle INSTR function with example queries. INSTR –tells the position

ORACLE Rank and Dense_rank functions – Learn how to calculate nth maximum and minimum value in the result set  based on the ranking mechanism either

PL-SQL Packages – Learn how to declare variables, functions, procedures , pl-sql types , constants, exceptions, cursors in Package specification section and how to implement

Oracle Analytical Ranking functions-Learn about few of analytical ranking functions like RANK and DENSE_RANK, ROW_NUMBER , NTILE FUNCTION, FIRST_VALUE, LAST_VALUE, NTH_VALUE with fully explained examples.

Oracle Predefined exceptions  – Learn about how exception occurs and how to handle errors with Examples. Exception It is an error that occur at the

FOR UPDATE and WHERE CURRENT OF Clause in Oracle -Learn how to perform record level locks while performing DML operations on table using Cursors. Below

Cursor with for loop in Oracle -Learn how to use cursors without using OPEN, FETCH and CLOSE  Statements and also learn how to use Select

Explicit cursor in Oracle- Learn about different types of cursors and their usage in oracle. and also learn how to create and use the cursors

Implicit cursor in Oracle PL-SQL – Learn how Oracle will perform the open, fetches, and close operations on a implicit cursor while executing DML statements