Oracle - rmauro.dev {blog}

rmauro.dev {blog}

Oracle

A collection of 9 posts

Oracle SYSDATE minus INTERVAL - Subtracting Time Units

Oracle SYSDATE minus INTERVAL - Subtracting Time Units

Oracle's `SYSDATE` function, combined with the `INTERVAL` keyword, provides a convenient way to manipulate dates and times.

Oracle Remove Duplicate from Table

Oracle Remove Duplicate from Table

Let's explore a one effective method to remove duplicate rows from an Oracle table. Duplicate data can be a common problem when working with databases, and it's crucial to eliminate such redundancy to ensure data accuracy and improve query performance. Using this simple query we can

Using dbms_stats to Gather Oracle Stats for Schema, Table and Indexes

Using dbms_stats to Gather Oracle Stats for Schema, Table and Indexes

Learn how to use dbms_stats to gather Oracle database statistics for schemas, tables, and indexes. This step-by-step guide covers essential commands to optimize database performance

Oracle ODP.NET with truly Async Methods in C#

Oracle ODP.NET with truly Async Methods in C#

Oracle's ODP.NET 23c Dev (or Oracle.ManagedDataAccess.Core) release brings genuine async/asynchronous methods to support to database interactions in C#, revolutionizing the way developers work with Oracle databases. Under PreRelease until today : 2023-08-24 Async/Await in C# Before delving into the specifics of ODP.NET 23c

Oracle PIVOT Command - Turn Rows into Columns

Oracle Featured

Oracle PIVOT Command - Turn Rows into Columns

Discover the technical prowess of Oracle's PIVOT command, a robust feature that efficiently converts rows into columns. This blog post delves into the syntax, use cases, and practical examples to illustrate how PIVOT simplifies data analysis and reporting in Oracle databases. Understanding the PIVOT Command The PIVOT command

Oracle JSON_TABLE Transforming JSON into Table

Oracle Featured

Oracle JSON_TABLE Transforming JSON into Table

The function JSON_TABLE allows us to transform JSON data into a table relational format. This article will explore the Oracle JSON_TABLE function and its syntax and provide examples to demonstrate its usage and capabilities.

Oracle MERGE Statement SQL

Oracle MERGE Statement SQL

Oracle MERGE statement is one of those powerful commands which allows you to perform INSERT and UPDATE operations in a single statement based on specific conditions.

Optimizing Query Performance on C# ODP.NET - Oracle Managed Data Access

Optimizing Query Performance on C# ODP.NET - Oracle Managed Data Access

Oracle C# drive is already pretty fast with the default configuration. But we can always tweak it a little to make it even faster. By controlling the FetchSize property in ODP.NET we can make fewer round trips to Oracle Database and fetch the data faster. Let's take

Oracle Database on Docker for Development

Oracle Database on Docker for Development

Lets set up an Oracle Database instance for development purpose using Docker is very easy. And it also runs in WSL2 over Windows. Let's use the oracleinanutshell/oracle-xe-11g image.