In this article, you will learn about different type of triggers in Oracle.

In this article, you will learn about Oracle Package DBMS METADATA.

In this article, I explain how to unlock the HR schema in Oracle 12c in detail. Sometimes while making the clone of production database into a test server this type of error occurs. So this article...

In the realm of data management and integration, the process of reading and uploading Excel data to an Oracle table involves multiple fundamental steps. First, the data needs to be read from an Exc...

In this article, you will learn about Create ,Insert, update, delete , select table , truncate table , drop table statement in Oracle Database / PL-SQL.

This article explains how to set up a connection between an Oracle database and .Net Framework using C#.

Using oracle database with .net core can be a hassle. By connecting oracle with dapper as a micro orm, life can get easy. Here we will discuss some effective way to establish a connection with orac...

This article explains the use of Sub Queries. Here we see examples of Multiple Row Sub Query, Multiple Column Sub Query, Nested Sub Query, Correlated Sub Query.

In this article, I share the use of a Sub Query. If a Query that contains another Query, then the Query inside the main Query is called a Sub Query and the main Query is known as the parent Query.

This article shows the use of Oracle cursors for loops with an appropriate example. The process of opening, fetching, and closing is handled implicitly by a cursors FOR LOOP. If there is a need to ...

This article introduces the term Cursors in Oracle. Cursors are the temporary private working area where queries are processed. Implicit Cursors and Explicit Cursors are two types of Cursors.

In this article, you will learn how to install your oracle 11g on window 7 with 64 bit.This article will guide you installation step especially for the fresher.

In this article you will learn about FlashBack Database in Oracle.

In this article, you will learn about SQL Loader utility in Oracle.

In this article, we will look into a new feature of Oracle 12c known as extended data types.

In this article, you will learn about Oracle 11gR2 RAC installation.

In this article, you will learn about Real Application Clusters (RAC) in Oracle.

In this article you will learn about the alternative for SQL Server Identity fields in Oracle.

This article explains how to connect to an Oracle database server without an Oracle client.

This article explains Cursors with their types with some examples that will help beginners.