rmauro.dev {blog}
  • home
  • privacy policy
  • rss

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.
May 24, 2023 2 min read
Oracle MERGE Statement SQL
oracle

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.
May 21, 2023 2 min read
Optimizing Query Performance on C# ODP.NET - Oracle Managed Data Access
oracle

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
Jun 10, 2022 3 min read
Oracle Database on Docker for Development
Docker

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.
May 30, 2022 2 min read
Page 1 of 1
rmauro.dev {blog} © 2023
  • youtube
  • github
  • twitter
  • discord
Powered by Ghost