oracle

Content
People

Sort By Search Results

Migrate and Run VMware Workloads to Oracle Cloud VMware SolutionApr 10, 2024. 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 Cloud VMware Solution.
Read And Upload Excel Data To Oracle TableOct 18, 2023. 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 file, which might contain various types of information such as numbers, texts, or dates. This data is typically organized in rows and columns.
Dynamic Menu Creation Using Oracle Database Jul 03, 2023. 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 fileMay 23, 2023. Setup Free Oracle Database in pod to perform DB operation with in Kubernetes cluster.
Fast Track Multi-Cloud Adoption With Oracle Cloud And Microsoft AzureMay 05, 2022. 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 CoreApr 01, 2022. 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.
Create, Insert, Update, Delete, Select, Truncate, Drop Statement In Oracle PL-SQLFeb 28, 2022. 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 NginxFeb 09, 2022. 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.
Docker Installation In Windows System Through Oracle Virtual BoxJan 10, 2022. How to install docker in windows system through oracle virtual box.
Working With LOB Data In Oracle And ASP.NET 5Oct 19, 2021. 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 them in Oracle.
Working With Spatial Data In Oracle And ASP.NET 5Sep 16, 2021. 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 geographical data in Oracle and ASP.NET 5 using dotConnect for Oracle as the ORM.
How To Link A SQL Server To An Oracle DatabaseFeb 26, 2021. This article describes what is Linked servers and how to link MS SQL Server to Oracle from SSMS
.Net Core With Oracle Database Using DapperJan 24, 2020. 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 database using .net core.
Blazor - Connect With Oracle Database In Amazon RDSOct 31, 2018. 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 Single Page Application for this purpose.
Step By Step Installation Of Oracle 11g On Windows 7 (64bit)Aug 21, 2018. 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#Jun 26, 2018. 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 to insert numerous amount of data into the database using one go. Means, rather than going one by one process which is a lengthy and time-consuming process, we prefer to insert whole data in one go into the database. So, today we will see, two different ways using that we can insert bulk data into Oracle database table using C#.
ASP.NET Core Web API With Oracle Database And DapperMay 30, 2018. This guide explores the creation of a Web API using ASP.NET Core, integrating with an Oracle Database through the Dapper ORM. Learn how to set up a robust backend service, implement CRUD operations, and optimize database interactions.
Connecting R Software With Oracle DBNov 24, 2017. 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
Look At Extended Data Types In Oracle 12cJul 27, 2016. In this article, we will look into a new feature of Oracle 12c known as extended data types.
Overview Of Oracle Package DBMS METADATAJul 21, 2016. In this article, you will learn about Oracle Package DBMS METADATA.
Upload Files And Save In Oracle Database In Blob Format In ASP.NETJul 08, 2016. In this article, you will learn how to upload files and save them in the Oracle database in Blob format in ASP.NET.
Learn Basics Of PL/SQL Oracle From Scratch In 7 Days - Day TwoMar 27, 2016. 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 OneMar 15, 2016. 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 FormNov 10, 2015. This guide covers setting up the connection string, configuring your .NET application, and managing database interactions through ADO.NET. Ideal for developers working with Oracle and C#.
Connect To Oracle Database Server Without Oracle ClientApr 28, 2015. This article explains how to connect to an Oracle database server without an Oracle client.
Fetch Data From Oracle Database Using C#Feb 16, 2015. his code demonstrates fetching data from an Oracle database using C# in ASP.NET. It connects to the database, executes a query to retrieve student data (name and roll number), and displays the results in a simple HTML table. The code utilizes the OracleDataReader object to read the retrieved data row by row.
Connecting To Oracle Database In C#Jan 18, 2015. This article explains how to set up a connection between an Oracle database and .Net Framework using C#.
How to Integrate Oracle With .NET FrameworkNov 04, 2014. 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.
Upload Excel/Text File Data Into Oracle Table Using TOADJul 20, 2014. This article explains how to insert data into an Oracle table from Excel or a flat text file using Import.
Constraints in Oracle : Part 2Oct 24, 2013. This article explains Foreign Key Constraints in Oracle.
Constraints in Oracle : Part 1Oct 23, 2013. 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 DatabaseOct 21, 2013. Let us understand how the user queries are handled at the oracle Database, what are all the processes involved in it.
Shutdown of Database in Oracle 11gOct 16, 2013. Here I am going to describe the shutdown process of a database.
Startup of Database in Oracle 11gOct 15, 2013. Considering that you have installed the oracle for the first time and is about to start the database instance.
Architecture of Oracle 11g: Part 1Oct 11, 2013. 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)Oct 11, 2013. 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)
SQL Server Functions and Oracle EquivalentMay 04, 2013. 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#Jan 10, 2013. In this article I will explain how to connect to an Oracle database from a Windows application using C#.
DataBase Connectivity and validation of data from Oracle Database in JAVA ServletNov 06, 2011. In this article you will learn how to connect to a Database and validate the data in a Java Servlet.
Integrating Oracle into SharePoint 2010 Using Business Data Connectivity Model Dec 21, 2010. Business Connectivity Services (BCS) is a new service introduced with SharePoint 2010 to allow SharePoint sites to connect to and manipulate external data. SharePoint 2007 had a similar facility in the form of Business Data Catalog (BDC) which made external data available within it's site.
How to Create WCF Service to Retrieve Data From the Oracle DatabaseDec 13, 2010. In this article, we will be seeing how to create WCF service to retrieve data from the Oracle database.
How to connect to Oracle database using WCF in SilverlightNov 28, 2010. In this article we will be seeing how to connect to the Oracle database using WCF in Silverlight and will perform a search to retrieve the data from the database, display them in the Silverlight data grid using Visual Studio 2010.
How to connect to the Oracle database using Business Connectivity Services (BCS) in SharePoint 2010Nov 17, 2010. Business Connectivity Services (BCS) is a new service introduced with SharePoint 2010 to allow SharePoint sites to connect to and manipulate external data.
Working with Oracle Databases using ADO.NET Mar 23, 2010.
Handling complex data types returned by Web services using JSON and jQuery in Microsoft.NET and Oracle ASApr 17, 2009. In this article, I will illustrate how to invoke an Ajax-enabled Web service which returns a complex data type (an array of products) from a Web service in Visual Studio.NET and JDeveloper.
jQuery and Ajax in Microsoft.NET and Oracle ASApr 16, 2009. In this article, I will explain how to consume an Ajax-enabled Web service using jQuery.
jQuery in Microsoft.NET and Oracle ASApr 14, 2009. jQuery is a lightweight JavaScript library CSS3 compliant to efficiently traverse HTML documents, handle events, perform actions and add interaction to the Web pages. In this article, I will explain how to use jQuery with Microsoft ASP.NET and Oracle Application Server (AS).
Calling Oracle stored procedures from Microsoft.NETJun 29, 2007. 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 in the namespace System.Data.OracleClient. I will cover several possible scenarios with advanced examples.
Sending Binary Data from Oracle Application Server to WCF through MTOM: Part IIJun 06, 2007. 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 interoperability between the two platforms.
Walkthrough: Displaying Data From Oracle Database in a Windows ApplicationMay 25, 2007. 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.
Sending Binary Data from Oracle Application Server to WCF through MTOM: Part IIMay 14, 2007. 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.
Enhanced Oracle Explorer in C# and .NET Using Windows FormsApr 27, 2007. 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.
Accessing Oracle Database from Microsoft.NET 2.0 using Oracle Data Provider for .NETApr 16, 2007. 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.
Interoperability between WCF and Oracle Application ServerApr 02, 2007. This article is to illustrate techniques and architecture that address the situation of one service running in WCF and a client consuming this service.
Interoperability between WCF and Oracle Application Server : Part IJan 24, 2007. This article is part of series intended to show how to use Web Services related technologies to interoperate applications running in different platforms, in this case, the most common scenario between Microsoft.NET and Oracle AS platforms.
Using ADO.NET concurrent model in Oracle databaseDec 07, 2006. The most popular instrument to access database data for .NET applications is ADO.NET. This set of components contains three main classes those are used to manipulate and store data: DataReader, DataSet and DataAdapter.
Retrieve Oracle BLOB and Save as a JPG Using ASP.NET 2.0Sep 01, 2006. 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#.
Insert /Retrieve an Image Into/ From a Blob Field in Oracle Database using C#.NetMar 17, 2006. This article helps you to insert an image to a blob field of an oracle database and to retrieve the image from the blob field of an oracle database.
How to Execute Oracle Stored Procedures Dynamically in C# Nov 10, 2005. In this article, I wiil show how we can store schema of stored procedures in an XML file and load and run the stored procedure from UI application using C# and Oracle.
How To Get All Database Tables and TableColumns in Oracle Nov 08, 2005. In this article, I will show how can I fetch all tables and corresponding columns from an Oracle database using C# and Oracle .NET Data Provider.
Microsoft CRM Integration: Oracle Database Access from MS CRMFeb 22, 2005. This article shows customization possibility demonstration for user web interface of Microsoft CRM.
Handling Oracle Max Open Cursor Error when Fetching Multiple Rows in ADO.NETAug 18, 2004. 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 other databases like Oracle the situation might turn out to be a little more tricky than it is with SQL Server.
Accessing Oracle DatabaseSep 21, 2001. This source code shows you how to connect to an oracle database and do operations such as select, insert, update and delete.
Connect to an Oracle DatabaseMay 03, 2001. This sample code shows you how to connect to an Oracle database using C#.
Oracle Stored Procedure Output Parameters with Dapper in ASP.NET CoreJun 11, 2024. This article provides a detailed guide to integrating Oracle stored procedures with ASP.NET Core using Dapper, focusing on handling output parameters, which can often be a challenging aspect of database interactions.
Oracle Database Server To SQL Server Migration Feb 11, 2020. In this article, you will learn about Oracle Database Server to Microsoft SQL Database Server Migration.
How To Unlock HR Schema In Oracle-12C Or How To Fix The ORA - 01033 Error Dec 12, 2019. 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 very helpful for those people who are new to Oracle 12c.
FlashBack Database In OracleSep 07, 2016. In this article you will learn about FlashBack Database in Oracle.
SQL Loader Utility In OracleAug 17, 2016. In this article, you will learn about SQL Loader utility in Oracle.
Learn about Different Type of Triggers in OracleAug 17, 2016. In this article, you will learn about different type of triggers in Oracle.
Oracle 11gR2 RAC Installation: Part OneJun 09, 2016. In this article, you will learn about Oracle 11gR2 RAC installation.
Oracle: Real Application Clusters (RAC)Jun 08, 2016. In this article, you will learn about Real Application Clusters (RAC) in Oracle.
Oracle Virtual Machine In AzureApr 13, 2016. In this article you will create Oracle Virtual Machine using Azure Portal.
Partition In OracleApr 11, 2016. 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'Mar 27, 2016. 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.
Alternate To Identity in OracleJul 18, 2015. In this article you will learn about the alternative for SQL Server Identity fields in Oracle.
Oracle Database Connection Using .NETJul 09, 2015. In this article we will learn how to make an Oracle database connection in .NET.
Cursors in OracleSep 30, 2014. This article explains Cursors with their types with some examples that will help beginners.
PL/SQL Control Statements in OracleSep 27, 2014. 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 actions based on conditions. These statements include IF-THEN-ELSE for conditional execution, CASE for multi-way branching, LOOP, WHILE for iterative processes, and FOR for looping through a range of values. These control statements are essential for creating structured and efficient programs in Oracle databases.
Stored Procedure For Insert, Update, Select, Delete Using OracleSep 25, 2014. This is a beginner's article showing how to create a Stored Procedure doing inserts, updates, selects and deletes using Oracle.
Oracle Operators: Part 3Jan 17, 2014. Let's continue with the third and the last part of Oracle Operators.
Oracle Operators: Part 2Jan 10, 2014. In this article we will learn how to use Set Operators in Oracle.
Oracle Operators: Part 1Jan 06, 2014. In Oracle, operators are used with the data items to perform the related actions and then return a result.
Exception Handling in OracleDec 24, 2013. 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 PartitioningDec 12, 2013. 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.
NTILE() Function in OracleNov 28, 2013. In this article you will learn about the Oracle NTILE function.
Reference Cursor in OracleNov 28, 2013. In this article you will learn about Reference Cursors in Oracle.
Oracle Golden Gate (GG)Nov 27, 2013. 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 TypesNov 27, 2013. In this article you will learn about Oracle record types.
Cursors In OracleNov 26, 2013. 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.
Cursors For Loop in OracleNov 26, 2013. 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 FETCH and PROCESS each and every record from a cursor, the cursor FOR LOOP is helpful for that.
Joins in Oracle: Part 2Nov 15, 2013. In this article you will learn about more Oracle Joins.
Joins in Oracle: Part 1Nov 13, 2013. 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 9Nov 12, 2013. In this article you will learn about more Oracle commands.
Oracle SQL Commands: Part 8Nov 08, 2013. In this article you will learn about various Oracle commands.
Oracle SQL Commands: Part 6Nov 07, 2013. In this article you will learn about various select commands in Oracle.
Oracle SQL Commands: Part 7Nov 07, 2013. In this article you will learn about various Oracle commands.
Sub Query in Oracle: Part 1Nov 06, 2013. 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.
Sub Query in Oracle: Part 2Nov 06, 2013. 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.
Oracle SQL Commands: Part 5Nov 01, 2013. In this article you will learn about various drop commands in Oracle.

1 - 100 of 126

OUR TRAINING