In this blog, you will learn about packages in Oracle.

In this blog, you will learn about batch file for taking Cold Backup and Expdp.

In this blog, we will look into doing character case insensitive string comparison in Oracle 12c.

In this blog, you will see the Oracle query to get the total count of pending counts department wise and drill down data In Oracle.

This blog will help you to understand how can we parse SQL query in oracle PL/SQL

In this blog you will learn about oracle 11g r2 Installation Error in Windows.

In this blog you will learn to String Aggregation in Oracle.

In oracle, without using a cursor, by directly using the for loop it can be done for multiple records to update multiple tables.

Here, we are going to explain the way for creating the stored procedure:

Generally when we execute any query or an argument the parameter acts as a placeholder for the values of a variable and return those values during the execution of stored procedure.

Here is a small description about creating and dropping functions in oracle.

Here is a small description of how to use the ORDER BY clause in any of the SET operations.

Below is the one by description of all the four date command with their syntax.

In Oracle, we basically use either Offline or Online backup. Here, although the words are different but the meaning is same our offline backup is called as COLD backup and online backup is known as...

Here is the difference between the commands that are used to remove the data from the database.

As both ROLLBACK and COMMIT Commands are TCC (Transaction Control Commands), but are not similar to each other.

Here is the difference between the ORACLE_HOME and ORACLE_BASE.

The above error commonly occurs while executing any SQL statement on database.

COALESCE function is most similar to CASE expression as we define the cases while using CASE expression