PL/SQL Returning Into

10 Jul 2023

The RETURNING INTO clause allows us to return column values for rows affected by DML statements. The returned data could be a single column, multiple columns or expressions.
Read more

Commenting the Stored Procedures

5 Jul 2023

Writings comments in the code will help you and anyone who reads the code by giving more readability and understandings...
Read more

Basic database monitoring queries in PL/SQL

21 Jun 2023

This is cheat sheet for basic database monitoring PL SQL queries.
Read more

Directory Objects in PL/SQL

2 Mar 2023

Catalog views are provided for DIRECTORY objects to enable users to view object names and corresponding paths and privileges.
Read more

Oracle Timestamp

21 Dec 2022

The TIMESTAMP datatype is an extension on the DATE datatype.
Read more

Drop table in PL SQL

25 Oct 2022

PL SQL Query to list the currently running jobs.
Read more

Column-Level Collation and Case-Insensitive Database in Oracle

24 Oct 2022

Collation determines how strings are compared, which has a direct impact on ordering (sorting) and equality tests between strings.
Read more

Oracle NLS / National Language Suppport

23 Oct 2022

The nls_database_parameters shows the values of the NLS parameters for the database.
Read more

List the months between two dates - PL/SQL

11 Oct 2022

PL SQL Query to list the months between two dates.
Read more