orac Resources

Share

Related resources for orac

What are SQL dialects with Example?4/19/2024 4:09:17 AM. SQL dialects are versions of SQL tailored to specific database systems. Each dialect has its syntax and features while adhering to SQL's core principles. Understanding dialects is essential for wr
How To Unlock HR Schema In Oracle-12C Or How To Fix The ORA - 01033 Error 4/10/2024 10:41:23 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
Migrate and Run VMware Workloads to Oracle Cloud VMware Solution4/10/2024 7:10:31 AM. Migrating VMware workloads to the cloud can be a complex but rewarding process. This article explores the benefits, challenges, and steps involved in migrating and running VMware workloads on Oracle C
Blazor - Connect With Oracle Database In Amazon RDS2/21/2024 11:32:58 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
How to Install Selenium Your Computer?11/2/2023 5:10:49 AM. This article provides a clear and detailed set of instructions for installing Selenium and its related components on your computer. It's particularly helpful for those new to Selenium and looking
Read And Upload Excel Data To Oracle Table10/18/2023 10:14:17 AM. 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 Excel
Oracle Connection String in C#10/11/2023 11:50:55 AM. We will learn connection string format for Oracle data providers in C#.
Oracle Data Provider for .NET : Part VII9/5/2023 6:08:17 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 f
Oracle Data Provider for .NET : Part VI9/5/2023 6:06:08 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 f
Oracle Data Provider for .NET: Part V9/5/2023 6:04:37 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 f
Oracle Data Provider for .NET : Part IV9/5/2023 6:00:33 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 f
Oracle Data Provider for .NET : Part III9/5/2023 5:57:57 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 f
Oracle Data Provider for .NET : Part II9/5/2023 5:55:04 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 f
Oracle Data Provider for .NET : Part I9/5/2023 5:47:12 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 f
Easily Connect to a Database In C#8/25/2023 10:24:29 AM. Connecting to a database in C# can be achieved using ADO.NET, a powerful technology for data access. With ADO.NET, you can easily establish connections to various database systems, such as SQL Server,
Partition In Oracle8/21/2023 11:28:34 AM. In this article you will learn about Partition in Oracle.
Startup of Database in Oracle 11g8/9/2023 11:05:56 AM. Considering that you have installed the oracle for the first time and is about to start the database instance.
Oracle database 11g and Microsoft SQL Server 20087/31/2023 4:34:50 AM. In this article, I want to cover the new features in Oracle 11g and SQL Server 2008 database systems which are two important players always fighting for the top spot in this important market segment o
Oracle: JDBC (Java Database Connectivity)7/27/2023 11:46:41 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 S
PL/SQL Control Statements in Oracle7/27/2023 11:37:40 AM. PL/SQL control statements are used to manage the flow of execution in Oracle's PL/SQL programming language. They enable developers to make decisions, iterate through data, and perform specific act
Connection Strings for All Databases7/27/2023 4:40:45 AM. This article shows step by step different ways to get connection strings for all types of databases. The article is written for all type of users, beginners, intermediate, experienced
Increasing your application performance with the client result_cache feature and ODP.NET7/25/2023 10:07:43 AM. In this article, I want to explain how to improve your application performance using Oracle Data Provider for .NET (ODP.NET) and the new features exposed by the underlying Oracle Call Interface.
Dynamic Menu Creation Using Oracle Database 7/3/2023 6:06:45 AM. In this article, I am going to share with you how to create dynamic menu in #Asp.Net using the oracle database.
Setup Oracle Database Pod in Kubernetes Cluster using YAML file5/23/2023 5:04:03 AM. Setup Free Oracle Database in pod to perform DB operation with in Kubernetes cluster.
Security in Database Systems2/14/2023 7:17:15 AM. In this article, I will cover the principles concerning security and its realization in Oracle database and Microsoft SQL Server.
Physical Data Organization and Indexing2/8/2023 8:44:31 AM. This article is intended to explain the main storage structures used in database systems through examples in Microsoft SQL Server and Oracle Database.
What Is Database Management1/27/2023 8:06:15 AM. In this article, you will learn what is Database Management.
Simulating Autonomous Transactions in Microsoft SQL Server1/14/2023 11:41:25 AM. In the article, I will cover how to use table variable techniques in order to simulate the autonomous transaction behavior of Oracle databases in Microsoft SQL Server.
SQL Server Functions and Oracle Equivalent1/9/2023 11:15:39 AM. This article looks at SQL Server string, numeric and date functions and their Oracle equivalents.
Materialized Views in Database Systems1/3/2023 8:39:31 AM. This article is intended to illustrate the concepts of materialized views in database systems and their realization through examples written for SQL Server and Oracle database systems.
Fast Track Multi-Cloud Adoption With Oracle Cloud And Microsoft Azure5/5/2022 3:24:06 AM. In this article, you will learn about fast track Multi-Cloud Adoption with Oracle Cloud and Microsoft Azure.
Persist Method Execution Metadata In Oracle Using ASP.NET Core4/1/2022 5:01:38 AM. This article presents a discussion on how we can capture method execution metadata such as execution time, method name, controller name, etc and save these details in an Oracle database.
Two Ways To Insert Bulk Data Into Oracle Database Using C#3/31/2022 9:26:38 AM. 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
Connecting to Oracle Database From Windows Forms Application Using C#3/29/2022 10:00:48 AM. In this article I will explain how to connect to an Oracle database from a Windows application using C#.
Create, Insert, Update, Delete, Select, Truncate, Drop Statement In Oracle PL-SQL2/28/2022 1:28:33 PM. In this article, you will learn about Create ,Insert, update, delete , select table , truncate table , drop table statement in Oracle Database / PL-SQL.
How To Deploy ASP.NET Core App/Web API On Oracle Linux Server Using Nginx2/9/2022 1:32:25 PM. In this article, you will learn how to deploy Asp.NET Core App / Web API in Oracle Linux 7.9 server using Nginx as reverse proxy.
Running ASP.NET Core In Linux System(Alpine Linux Distribution) Using Docker2/9/2022 6:43:20 AM. In this article, you will learn how to run Asp.net Core In Linux system(Alpine Linux Distribution) using docker.
Docker Installation In Windows System Through Oracle Virtual Box1/10/2022 11:10:56 AM. How to install docker in windows system through oracle virtual box.
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.
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
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.
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.
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.
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.
Table Splitting Delete Data Using Code First Apporach5/24/2015 12:57:38 PM. This article shows how to do table splitting and delete data operations using Code First Approach.
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.
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.

Topics