Welcome to oracle section of C# Corner. In this section, you will find oracle related source code samples, articles, tutorials, and tips.


  • Labib Hossain

    .Net Core With Oracle Database Using Dapper

    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...
    Labib Hossain Jan 24, 2020
  • Sanghdeep Sanghratne

    How To Unlock HR Schema In Oracle-12C Or How To Fix The ORA - 01033 Error

    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...
  • Nipun Tomar

    Sub Query in Oracle: Part 2

    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.
    Nipun Tomar Nov 06, 2013
  • Nipun Tomar

    Sub Query in Oracle: Part 1

    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.
    Nipun Tomar Nov 06, 2013
  • Nipun Tomar

    Cursors For Loop in Oracle

    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 ...
    Nipun Tomar Nov 26, 2013
  • Nipun Tomar

    Cursors In Oracle

    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.
    Nipun Tomar Nov 26, 2013
  • Vikas Srivastava

    Step By Step Installation Of Oracle 11g On Windows 7 (64bit)

    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.
    Vikas Srivastava Aug 21, 2018
  • Paras Babbar

    Connecting To Oracle Database Using C#

    This article explains how to set up a connection between an Oracle database and .Net Framework using C#.
    Paras Babbar Jan 18, 2015
  • Akshay Phadke

    FlashBack Database In Oracle

    In this article you will learn about FlashBack Database in Oracle.
    Akshay Phadke Sep 07, 2016
  • Saillesh Pawar

    SQL Loader Utility In Oracle

    In this article, you will learn about SQL Loader utility in Oracle.
    Saillesh Pawar Aug 17, 2016
  • Akshay Phadke

    Learn About Different Type Of Triggers In Oracle

    In this article, you will learn about different type of triggers in Oracle.
    Akshay Phadke Aug 17, 2016
  • Sateesh Arveti

    Look At Extended Data Types In Oracle 12c

    In this article, we will look into a new feature of Oracle 12c known as extended data types.
    Sateesh Arveti Jul 27, 2016
  • Sateesh Arveti

    Overview Of Oracle Package DBMS METADATA

    In this article, you will learn about Oracle Package DBMS METADATA.
    Sateesh Arveti Jul 21, 2016
  • Akshay Phadke

    Oracle 11gR2 RAC Installation: Part One

    In this article, you will learn about Oracle 11gR2 RAC installation.
    Akshay Phadke Jun 09, 2016
  • Akshay Phadke

    Oracle: Real Application Clusters (RAC)

    In this article, you will learn about Real Application Clusters (RAC) in Oracle.
    Akshay Phadke Jun 08, 2016
  • Pankaj  Kumar Choudhary

    Alternate To Identity in Oracle

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

    Connect To Oracle Database Server Without Oracle Client

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

    Cursors in Oracle

    This article explains Cursors with their types with some examples that will help beginners.
    Rupesh Kahane Sep 30, 2014
  • Sesuraj

    Stored Procedure For Insert, Update, Select, Delete Using Oracle

    This is a beginner's article showing how to create a Stored Procedure doing inserts, updates, selects and deletes using Oracle.
    Sesuraj Sep 25, 2014
  • Nipun Tomar

    Oracle Operators: Part 3

    Let's continue with the third and the last part of Oracle Operators.
    Nipun Tomar Jan 17, 2014
  • View More