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


  • 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 Oct 27, 2020
  • Pooja

    Function to Return Number Of Specified Days Between Two Dates

    In this post, we are using SQL to create a function that will return the number of specified days between two dates.
    Pooja Sep 25, 2020
  • 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...
  • Artur M

    PL/SQL - Fast Import Data Into A Database

    Very often, we face the problem of how to import data from files to the database. PL/SQL provides an interesting solution: external tables. In this video, we will learn all about external tables.
    Artur M Aug 29, 2019
  • Artur M

    PL/SQL Optimization: Table Partitions

    Using a partition allows you to divide a large table into smaller portions. This allows us to speed up the execution of many queries. And this is what this lesson will be about.
    Artur M Aug 22, 2019
  • Artur M

    PL/SQL Video Tutorial For Beginners

    Oracle is one of the most popular RDBMS (Relational Database Management System). PL/SQL (Procedural Language for SQL) is Oracle procedural extension for SQL. In this tutorial, you will learn the ba...
    Artur M Aug 20, 2019
  • Zia Ahmed Shaikh

    Installing Oracle VirtualBox on Windows 8/10 and Create a Virtual Machine

    In this video, I have explained the process of downloading virtual-box software from Oracle's site and then we will go into its installation process. After installation, we will create a Virtua...
    Zia Ahmed Shaikh Sep 25, 2018
  • 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 Sep 03, 2018
  • 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 Sep 03, 2018
  • 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 Aug 31, 2018
  • 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 Aug 31, 2018
  • 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
  • Kuldeep Singh

    Oracle introduces GraphPipe for Machine Learning Deployment

    Recently, Oracle has introduced GraphPipe, an open source framework, to simplify and standardize machine learning model deployment.
    Kuldeep Singh Aug 17, 2018
  • Abhay Dixit

    Oracle Drag And Drop Tools Makes Easy To Build Apps

    Oracle has recently demonstrated the Autonomous Visual Builder to make it easy to create mobile applications using a simple drag and drop approach.
    Abhay Dixit Jun 18, 2018
  • Tahseen  Jamil

    Oracle Plans To Charge Free Java Users

    Oracle seems to be cracking down on non-paying Java users.
    Tahseen Jamil Dec 21, 2016
  • Tahseen  Jamil

    Oracle Database Release 2 (12.2) Now Available On Oracle Cloud

    Oracle Database 12c Release 2 (12.2) is now available with a range of scalable database services on Oracle Cloud, which include the new entry – level Exadata Express Cloud Service.
    Tahseen Jamil Nov 11, 2016
  • 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 18, 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
  • Akshay Phadke

    Packages In Oracle

    In this blog, you will learn about packages in Oracle.
    Akshay Phadke Aug 08, 2016
  • Akshay Phadke

    Batch File For Taking Cold Backup And Expdp

    In this blog, you will learn about batch file for taking Cold Backup and Expdp.
    Akshay Phadke Aug 08, 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
  • Sateesh Arveti

    Enable Case Insensitive String Comparison In Oracle 12C

    In this blog, we will look into doing character case insensitive string comparison in Oracle 12c.
    Sateesh Arveti Jul 14, 2016
  • View More