oracle - rmauro.dev {blog}

rmauro.dev {blog}

oracle

A collection of 4 posts

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 a look

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.