Develop and administer Oracle databases and apps. Learn SQL and PL/SQL, indexing, performance tuning, partitions, RAC, backups, Data Guard, security, and APEX. Get deployment tips and automation scripts for stable, compliant environments.
384 posts203 contributors
Master OCI routing: Understand route tables, VCNs, subnets, NAT Gateways, DRGs, and VCN peering for seamless cloud network communication.
Unlock peak .NET performance with Dapper and Oracle! This guide covers setup, CRUD operations, type handling, and crucial optimizations for high-throughput apps.
Explore Oracle Cloud's Virtual Cloud Network (VCN): a private, secure network for instances, internet, and on-premises connections. Master cloud networking!
Unlock the power of Oracle Cloud Infrastructure (OCI) Compartments! Learn how to effectively organize, isolate, and control access to your cloud resources. This guide explains how compartments enhance security, streamline management, and align with your organizational structure. Discover nested compartments, quotas, budgets, and global access for optimal cloud governance. Master OCI compartments for a secure and well-managed cloud environment.
Explore OCI's architecture: Regions, Availability Domains, and Fault Domains. Learn how these components ensure high availability, data protection, and disaster recovery.
Understand Oracle Cloud Infrastructure (OCI) Identity and Access Management (IAM). Learn how IAM uses authentication and authorization to control access to your cloud resources. Discover key components like identity domains, users, groups, policies, and compartments. Explore Oracle Cloud IDs (OCIDs) and how they uniquely identify resources, ensuring a secure cloud environment by granting the right permissions to the right people.
Oracle has evolved from being just a database company to becoming a comprehensive cloud and enterprise technology provider. With a strong focus on innovation, security, and performance, Oracle continues to power the digital backbone of many organizations worldwide.
In this article, you will learn about different type of triggers in Oracle.
In this article, you will learn about Oracle Package DBMS METADATA.
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.
Upload an Excel file in ASP.NET, read worksheet data with OleDb into a DataSet, and insert each row into an Oracle table.
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.
In this article, you will learn about Create ,Insert, update, delete , select table , truncate table , drop table statement in Oracle Database / PL-SQL.
This article explains how to set up a connection between an Oracle database and .Net Framework using C#.
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.
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.
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.
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.
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.
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.
In this article you will learn about FlashBack Database in Oracle.
In this article, you will learn about SQL Loader utility in Oracle.
In this article, we will look into a new feature of Oracle 12c known as extended data types.
In this article, you will learn about Oracle 11gR2 RAC installation.
In this article, you will learn about Real Application Clusters (RAC) in Oracle.