To PostgreSQL

8 May 2025

Earlier this week, I went to a seminar on Amazon AWS conducted by one of their partner organizations.
Read more

Connecting MySQL from command line

13 February 2024

Open the command prompt and type the below to connect the MySQL:
Read more

PL/SQL Returning Into

10 July 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 July 2023

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

Oracle Timestamp

21 December 2022

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

Drop table in PL SQL

25 October 2022

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

Column-Level Collation and Case-Insensitive Database in Oracle

24 October 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 October 2022

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

Database Management System (DBMS)

14 August 2022

A database management system (DBMS) is software that controls the storage, organization, and retrieval of data....
Read more