Connecting MySQL from command line

13 Feb 2024

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

Read more

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. As you know the complier ignores the comments and there is no straight way to verify the comments, we should make sure that the comments are easily readable and should not duplicate the code.

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

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

Database Management System (DBMS)

14 Aug 2022

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