Oracle Resources

About Oracle

Oracle term is dealing with the relational database management system called RDBMS by the Oracle Corporation and Originally developed in 1977 by Lawrence Ellison and other developers. Oracle is too big it organization company which provide the database for store information in large amount and it is only one of the most trusted and widely-used relational database engines. Whole the system is built around a relational database framework in which data objects may be directly accessed by users by structured query language (SQL). Oracle is scalable relational database architecture which is used by global enterprises which are manage and process data across wide and local area networks. Oracle is also known as Oracle RDBMS and sometimes called as just Oracle. Oracle is the first database designed for enterprise grid computing, the most flexible and cost effective way to manage information and applications.

Share

Related resources for Oracle

Working With LOB Data In Oracle And ASP.NET 510/19/2021 12:46:37 PM. LOBs enable you to store vast quantities of data in a database. Oracle provides excellent support for working with LOB data. This article talks about what LOBs are, their purpose and how to work with
Working With Spatial Data In Oracle And ASP.NET 59/16/2021 12:51:39 PM. Spatial data, often known as geospatial data, is information about a physical item represented numerically in a geographic coordinate system. The article talks briefly explains how to deal with geogra
Connecting To Oracle Database In C#9/10/2021 3:56:42 AM. This article explains how to set up a connection between an Oracle database and .Net Framework using C#.
How To Link A SQL Server To An Oracle Database2/26/2021 6:18:45 PM. This article describes what is Linked servers and how to link MS SQL Server to Oracle from SSMS
How To Create Missing Index From Execution Plan1/7/2021 8:46:49 PM. In this article, I am going to explain how to create a missing index from an SQL server query execution plan and also show you how you can improve your query execution performance and run your query f
Oracle Database Connection Using .NET11/5/2020 9:10:36 AM. In this article we will learn how to make an Oracle database connection in .NET.
Fetch Data From Oracle Database Using C#11/4/2020 9:19:45 AM. In this article you will learn how to fetch data from an Oracle database using C#.
Handling Oracle Max Open Cursor Error when Fetching Multiple Rows in ADO.NET11/2/2020 12:15:11 AM. When working with Microsoft technologies, MS SQL Server comes out as a natural choice for the database. While it is a fact that .NET Framework has extensive support for SQL server, when you work with
Accessing Oracle Database from Microsoft.NET 2.0 using Oracle Data Provider for .NET10/28/2020 6:42:50 AM. This article is intended to show how to access the Oracle database using ADO.NET programming model and Oracle Data Provider for .NET (ODP.NET) that Oracle makes available.
TranslateSQL10/28/2020 3:12:57 AM. TranslateSQL is a utility for generating SQL-Server SQL scripts based on an existing Oracle schema, in essence 'translating' Oracle schemas into SQL-Server databases.
Oracle Connection String in C#10/15/2020 7:58:35 AM. We will learn connection string format for Oracle data providers in C#.
Calling Oracle stored procedures from Microsoft.NET5/15/2020 2:16:24 AM. This article is intended to illustrate how to illustrate how to call Oracle stored procedures and functions from Microsoft.NET through the Microsoft.NET Oracle provider and its object model residing i
Oracle Database Server To SQL Server Migration 2/11/2020 11:01:56 PM. In this article, you will learn about Oracle Database Server to Microsoft SQL Database Server Migration.
.Net Core With Oracle Database Using Dapper1/24/2020 10:54:06 PM. 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 oracle
How To Unlock HR Schema In Oracle-12C Or How To Fix The ORA - 01033 Error 12/12/2019 9:25:53 AM. 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 is
Sending Binary Data from Oracle Application Server to WCF through MTOM: Part II9/20/2019 4:37:01 AM. This article will illustrate how to send binary data from Oracle Application Server (Oracle AS) to WCF using Web Services technologies specifically MTOM standard specification, thus achieving interope
How to Create WCF Service to Retrieve Data From the Oracle Database9/10/2019 5:23:56 AM. In this article, we will be seeing how to create WCF service to retrieve data from the Oracle database.
DataBase Connectivity and validation of data from Oracle Database in JAVA Servlet9/9/2019 1:36:06 AM. In this article you will learn how to connect to a Database and validate the data in a Java Servlet.
PL/SQL - Fast Import Data Into A Database8/29/2019 3:13:46 AM. 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.
PL/SQL Optimization: Table Partitions8/22/2019 7:51:15 AM. 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.
PL/SQL Video Tutorial For Beginners8/20/2019 11:40:50 PM. 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 basic
How to Save Records in Oracle10g Database Using Java7/30/2019 2:16:33 AM. This article shows how to save data in a database in a simple program in Java. We use an Oracle 10g database and Java 1.7; for connectivity we use a pure Java (Type 4) driver provided by Oracle.
How To Connect Java With Oracle10g Database7/25/2019 5:34:51 AM. This article explains how to connect to the Oracle10g database in Java.
Blazor - Connect With Oracle Database In Amazon RDS10/31/2018 9:33:11 AM. We will see how to create an Oracle database instance in Amazon RDS (AWS Relational Database Service) and we will connect Oracle database from Blazor application. We will use an Employee details Singl
Installing Oracle VirtualBox on Windows 8/10 and Create a Virtual Machine9/25/2018 2:28:08 AM. 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 Virtual M
Sub Query in Oracle: Part 29/3/2018 11:43:43 PM. 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.
Sub Query in Oracle: Part 19/3/2018 3:18:06 AM. 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.
Cursors For Loop in Oracle8/31/2018 6:10:05 AM. 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 FET
Cursors In Oracle8/31/2018 5:49:38 AM. 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.
Step By Step Installation Of Oracle 11g On Windows 7 (64bit)8/21/2018 12:19:07 AM. 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.
Two Ways To Insert Bulk Data Into Oracle Database Using C#6/26/2018 4:11:48 PM. This article will explain how we can insert bulk amount of data in Oracle database using C#. Generally, what happens, we insert one by one record into the database, but sometimes, we have requirements
ASP.NET Core Web API With Oracle Database And Dapper5/30/2018 10:16:57 AM. This article will focus on how to create Asp.Net Core Web API to get data from Oracle database using Dapper ORM. First thing, here we are not using SQL, because of so many articles available on Intern
Connecting R Software With Oracle DB11/24/2017 5:35:20 PM. This article is about how to connect the R software with Oracle database so that the data can be brought inside R environment for analysis
FlashBack Database In Oracle9/7/2016 11:32:42 AM. In this article you will learn about FlashBack Database in Oracle.
SQL Loader Utility In Oracle8/18/2016 10:16:00 PM. In this article, you will learn about SQL Loader utility in Oracle.
Learn About Different Type Of Triggers In Oracle8/17/2016 4:53:44 PM. In this article, you will learn about different type of triggers in Oracle.
Look At Extended Data Types In Oracle 12c7/27/2016 2:07:33 PM. In this article, we will look into a new feature of Oracle 12c known as extended data types.
Overview Of Oracle Package DBMS METADATA7/21/2016 3:02:16 PM. In this article, you will learn about Oracle Package DBMS METADATA.
Upload Files And Save In Oracle Database In Blob Format In ASP.NET7/8/2016 7:35:19 PM. In this article, you will learn how to upload files and save them in the Oracle database in Blob format in ASP.NET.
Oracle 11gR2 RAC Installation: Part One6/9/2016 12:14:38 PM. In this article, you will learn about Oracle 11gR2 RAC installation.
Oracle: Real Application Clusters (RAC)6/8/2016 12:59:33 PM. In this article, you will learn about Real Application Clusters (RAC) in Oracle.
Oracle Virtual Machine In Azure4/13/2016 1:43:17 PM. In this article you will create Oracle Virtual Machine using Azure Portal.
Partition In Oracle4/11/2016 11:25:09 AM. In this article you will learn about Partition in Oracle.
Fix to Rule 'Oracle JRE 7 Update 51 64-bit or Higher Is Required For Polybase Failed'3/28/2016 9:50:03 AM. In this article we will are going to see how we can fix the error rule “Oracle JRE 7 Update 51 (64-bit) or higher is required for Polybase” failed.
Learn Basics Of PL/SQL Oracle From Scratch In 7 Days - Day Two3/27/2016 5:17:27 PM. This article is based on learning basics of Oracle and SQL concepts in order to be an Oracle PL/SQL developer. This is day two of the article series.
Learn Basics Of Oracle PL/SQL From Scratch In 7 Days - Day One3/16/2016 2:12:58 PM. In this article you will learn about the basics of Oracle PL/SQL from scratch. This is day one of the article series.
Using Oracle Connection String In Windows Form11/10/2015 12:27:56 AM. This article is about using Oracle database in windows form using a connection string.
Alternate To Identity in Oracle7/18/2015 3:04:38 PM. In this article you will learn about the alternative for SQL Server Identity fields in Oracle.
Connect To Oracle Database Server Without Oracle Client4/28/2015 3:58:03 PM. This article explains how to connect to an Oracle database server without an Oracle client.
How to Integrate Oracle With .NET Framework11/4/2014 4:35:06 PM. In this article I would like to explain how to integrate Oracle with the .NET Framework and provide support for versioning issues that often occur when deploying projects on IIS.
Cursors in Oracle9/30/2014 6:56:23 PM. This article explains Cursors with their types with some examples that will help beginners.
PL/SQL Control Statements in Oracle9/29/2014 12:29:57 AM. This article explains control statements in PL/SQL for beginners.
Stored Procedure For Insert, Update, Select, Delete Using Oracle9/25/2014 9:31:54 PM. This is a beginner's article showing how to create a Stored Procedure doing inserts, updates, selects and deletes using Oracle.
Upload Excel/Text File Data Into Oracle Table Using TOAD7/20/2014 3:17:13 PM. This article explains how to insert data into an Oracle table from Excel or a flat text file using Import.
Oracle Operators: Part 31/17/2014 11:36:02 AM. Let's continue with the third and the last part of Oracle Operators.
Oracle Operators: Part 21/17/2014 6:16:50 AM. In this article we will learn how to use Set Operators in Oracle.
Oracle Operators: Part 11/10/2014 5:15:27 AM. In Oracle, operators are used with the data items to perform the related actions and then return a result.
Exception Handling in Oracle12/24/2013 1:05:14 PM. Generally, in PL/SQL while executing a program we might encounter an error. They can occurr during execution and are called an “EXCEPTION”. It will disrupt the normal flow of the program’s execution.
Oracle Partitioning12/12/2013 2:34:12 PM. In Oracle Partition is just like “Divide and conquer” approach, it is way or ability of database which allows a DBA to physically Split/ braked up all the very large tables, indexes and index organized tables in to smaller and manageable pieces/segments.
Reference Cursor in Oracle11/28/2013 10:18:20 PM. In this article you will learn about Reference Cursors in Oracle.
NTILE() Function in Oracle11/28/2013 12:32:42 PM. In this article you will learn about the Oracle NTILE function.
Oracle Golden Gate (GG)11/27/2013 3:32:01 PM. This article introduces Golden gate, a comprehensive software package that enables cost-effective and low-impact real-time data integration and continuous availability solutions.
Oracle Record Types11/27/2013 2:09:37 PM. In this article you will learn about Oracle record types.
Joins in Oracle: Part 211/15/2013 2:03:06 PM. In this article you will learn about more Oracle Joins.
Joins in Oracle: Part 111/15/2013 12:38:36 AM. In Oracle, join is the most powerful operation which is used to merge the information from different tables based on the common field between them.
Oracle SQL Commands: Part 911/12/2013 1:22:57 PM. In this article you will learn about more Oracle commands.
Oracle SQL Commands: Part 811/12/2013 2:57:11 AM. In this article you will learn about various Oracle commands.
Oracle SQL Commands: Part 711/8/2013 6:11:27 AM. In this article you will learn about various Oracle commands.
Oracle SQL Commands: Part 611/7/2013 12:53:18 PM. In this article you will learn about various select commands in Oracle.
Oracle SQL Commands: Part 511/7/2013 6:23:00 AM. In this article you will learn about various drop commands in Oracle.
Oracle SQL Commands: Part 411/7/2013 2:55:33 AM. In this article you will learn about various alter and drop commands in Oracle.
Oracle SQL Commands : Part 3 10/31/2013 6:22:46 AM. In Oracle we can create our own procedure. A procedure is a collection of SQL statement that can be called by any valid object name and create a user-defined procedure we use the command create Procedure.
Oracle SQL Commands: Part 210/29/2013 12:10:00 PM. In this article you will learn about various create trigger commands in SQL Server.
Oracle SQL Commands: Part 110/29/2013 12:09:39 PM. While using SQL there are some queries we can use on a frequent basis, since these queries play a vital role in storing the data into the database.
Constraints in Oracle : Part 210/25/2013 1:38:42 AM. This article explains Foreign Key Constraints in Oracle.
Constraints in Oracle : Part 110/25/2013 1:34:47 AM. This article explains the Constraint clause in Oracle that is basically used to apply the specific rules to the data that restrict the values/data entered into the database columns.
Transactions in Oracle Database10/21/2013 10:34:38 AM. Let us understand how the user queries are handled at the oracle Database, what are all the processes involved in it.
Oracle Process Structure : Part 210/17/2013 3:53:02 PM. In this article you will learn about various types of processes in Oracle.
Shutdown of Database in Oracle 11g10/16/2013 10:54:21 PM. Here I am going to describe the shutdown process of a database.
Oracle Process Structure : Part 110/16/2013 2:42:25 PM. Recently I read about the Process of Oracle and want to share my knowledge of it with you all.
Startup of Database in Oracle 11g10/15/2013 1:50:10 PM. Considering that you have installed the oracle for the first time and is about to start the database instance.
Architecture of Oracle 11g: Part 110/11/2013 4:55:48 PM. Today, we will explain the Oracle 11g architecture. It is basically divided into the three major parts, Memory Structure, Logical Database Structure and Physical Structure
Architecture of Oracle 11g (Part 2)10/11/2013 1:02:28 PM. In continuation of my previous article, here we will go through the second part of the memory structure of the Oracle architecture which is known as PGA (Program Global Area)
How to Fetch Records From Database Using Servlet in Java10/5/2013 4:51:58 PM. This article explains how to fetch data from a database using a Servlet in Java. The NetBeans IDE is used for this application.
SQL Server Functions and Oracle Equivalent5/4/2013 5:31:41 PM. This article looks at SQL Server string, numeric and date functions and their Oracle equivalents.
Connecting to Oracle Database From Windows Forms Application Using C#1/10/2013 5:38:24 PM. In this article I will explain how to connect to an Oracle database from a Windows application using C#.
Oracle Data Provider for .NET: Part V10/20/2012 4:49:47 AM. Oracle Data Provider for .NET (ODP.NET) is an implementation of a data provider for the Oracle database. ODP.NET uses Oracle native APIs to offer fast and reliable access to Oracle data and features from any .NET application.
Oracle Data Provider for .NET : Part VII10/20/2012 4:48:16 AM. Oracle Data Provider for .NET (ODP.NET) is an implementation of a data provider for the Oracle database. ODP.NET uses Oracle native APIs to offer fast and reliable access to Oracle data and features from any .NET application.
Oracle Data Provider for .NET : Part I10/20/2012 4:46:03 AM. Oracle Data Provider for .NET (ODP.NET) is an implementation of a data provider for the Oracle database. ODP.NET uses Oracle native APIs to offer fast and reliable access to Oracle data and features from any .NET application.
Performance Tuning in Database Systems10/5/2012 2:52:32 PM. In this article, we’re going to learn the principles and techniques you can use to help troubleshoot and evaluate query performance by illustrating examples in Microsoft SQL Server and Oracle database.
Database Server-side Applications.Extensions to SQL10/4/2012 10:07:53 AM. Developers have struggled with the power and limitations of SQL. SQL is language oriented to manipulate data set, but enterprise applications always need to implement business logic that goes beyond the reach of SQL. This article is intended to illustrate the main constructs in these database management systems.
Oracle: JDBC (Java Database Connectivity)9/30/2012 5:10:08 AM. JDBC (Java database connectivity) is the specification of the standard application programming interface that provides a standard library for accessing relational databases like MS-Access, Oracle or Sybase.
Cursors in Database Management Systems5/20/2012 4:50:17 AM. This article is intended to show the principles and uses of cursors in relational database management systems. We’re going to discuss how cursors are implemented in Microsoft SQL Server and Oracle database and how you can use it in your applications.
Crystal Reports - Geterogeneus databases: SQL Server, Oracle, Unidata, Btrieve5/19/2012 3:58:40 AM. Crystal Reports is the most flexible tool on the market and it has market recognition. Multiple software vendors offer Crystal Reports as the main reporting tool: Microsoft, Best Software, Oracle to name a few. In this article, you learn some tips on using Crystal Reports versus other options.
Sending Binary Data from Oracle Application Server to WCF through MTOM: Part II5/19/2012 12:39:09 AM. This article will illustrate how to send binary data from Windows Communication Foundation (WCF) to Oracle Application Server (Oracle AS) using Web Services specifications specifically MTOM standard specification, thus achieving interoperability between the two platforms. Some days ago, I blogged information in CSharpCorner blogs about MTOM specifications.
How to pass SQL Query Parameters to Crystal Reports using Oracle5/19/2012 12:11:47 AM. This article shows how to pass SQL query parameters to Crystal Reports using Oracle.
Enhanced Oracle Explorer in C# and .NET Using Windows Forms5/15/2012 7:13:46 PM. This application will allows to do multiple simple activities on oracle database like running select statements and getting selected procedure's definition simultaneously in a thread-based GUI.
Walkthrough: Displaying Data From Oracle Database in a Windows Application5/15/2012 6:45:49 PM. This article is intended to illustrate one of the most common business scenarios such as displaying data from Oracle database on a form in a Windows application using DataSet objects and .NET Framework Data Provider for Oracle.
Retrieve Oracle BLOB and Save as a JPG Using ASP.NET 2.05/15/2012 2:36:26 PM. The attached code snippet in this article shows how to retrieve Oracle BLOB column data and save as a JPEG file using ASP.NET 2.0 and C#.
Abstract Factory Pattern5/15/2012 2:27:20 PM. In this walkthrough I'll try to explain GOF (Gang of Four) Abstract Design pattern. This article is about managing multiple connection strings of different data providers (SQL, Oracle, OleDB etc.).

Topics