Articles by Tag #oracle
Browse our collection of articles on various topics related to IT technologies. Dive in and explore something new!
Why I Stopped Sending Data to LLMs: Introducing "Zero-Data Transport" Architecture
Why I Stopped Sending Data to LLMs: Introducing "Zero-Data Transport" Architecture ...
Querying & Filtering in Oracle Databases: What Actually Clicked for Me As a Beginner
Today felt like one of those quiet but important SQL days. No new tables. No fancy joins. Just...
Columns & Data Types in Oracle: What Actually Stuck on Day 2 (As a Beginner)
Day 2 of learning Oracle SQL was less about writing fancy queries and more about understanding what...
Recuperando dados no Oracle (sem envolver o DBA) com FlashBack Query
Sabe quando você faz aquela trapalhada épica, dá um UPDATE na tabela sem WHERE e ainda estava tão...
Beyond Text: Building an AI-Powered Color Matcher in Oracle FreeSQL
☁️ Pre-Flight Checklist This is a connection flight. Before we taxi down the runway,...
Funções de Conversão e Expressões Condicionais em SQL Oracle
Este artigo explora de forma detalhada as funções de conversão e expressões condicionais no Oracle...
![Algo entre o VARCHAR2 e o CLOB: VARCHAR2 com esteróides [MAX_STRING_SIZE]](https://media2.dev.to/dynamic/image/width=1000,height=420,fit=cover,gravity=auto,format=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fvugpf1vetgap6er5ox7y.webp)
Algo entre o VARCHAR2 e o CLOB: VARCHAR2 com esteróides [MAX_STRING_SIZE]
Há aproximadamente 5 anos, quando estava desenvolvendo um módulo de CRM, precisei implementar um...
Lessons from Converting Oracle Forms to Modern Web Apps
Oracle Forms has been a workhorse for business applications for decades, but as we move further into...
Hosting a Godot Server on Oracle Cloud
Introduction When working on multiplayer projects hosting a server is a key part of being...
PDB Recovery Isolation
In Oracle Database version 19c, Data Guard cannot manage operations such as hot cloning or...
Your First AI-Powered Search on Oracle Cloud: A Beginner's Guide to Vectors
☁️ Pre-Flight Checklist This is a connection flight. Before we taxi down the runway,...
Oracle 23ai's Phantom Vector Memory: A Troubleshooting Guide
☁️ Pre-Flight Checklist Before we taxi down the runway, here’s your flight plan. Keep this...
No More VMs: Run Oracle Database 23ai Natively on Apple Silicon in Seconds
⚡️ 30-Second Quick Start (Copy/Paste and Run) docker run -d --name oracle-free -p...
Understanding ORDS Pre-Hook Functions
In Oracle REST Data Services (ORDS), pre-hook functions are utilised to perform preliminary checks...
Unlocking the Oracle ACE Program: From Contribution to Recognition
I started contributing to the Oracle communities in 2008, engaging with fellow developers and solving...
Bringing OIC Execution Logs into APEX‑Driven Logging Tables
As integrations proliferate and complexity grows, having the ability to see what's happening behind...
SQL*Plus: Guia Completo para Gerenciamento de Banco de Dados Oracle
SQL*Plus é uma ferramenta interativa de linha de comando desenvolvida pela Oracle que permite aos...
Mastering DBMS: A Practical Guide to Indexing, Hashing, and Query Optimization
Introduction In the world of database management, performance is key. One of the most effective ways...
🏢 Why Spring Boot, Kafka, Oracle, and Tomcat Still Power the Enterprise in 2025
Every few months, new frameworks, databases, and cloud platforms appear — each promising to...
DBMS_JOB and DBMS_SCHEDULER Integration in Oracle 19c
Before Oracle 10g, the DBMS_JOB package was used to create jobs in the database environment. In...
Expression-Based Parameter Value Feature in Oracle 21c
In Oracle 21c, you can define the value of a parameter using environment variables or even by...
Oracle 21c — Using Result Cache in Standby
Another new feature introduced in Oracle Database 21c is the ability to use the RESULT_CACHE hint in...
FAR SYNC Data Guard
One of the new features introduced in Oracle 12c is FAR SYNC Data Guard, which has some similarities...
Understanding ACID Properties with Oracle Live SQL
INTRODUCTION ACID properties are a set of principles that guarantee the reliability of database...
Mastering Database Normalization with Oracle Live SQL: A Practical Guide
Introduction Have you ever wondered why your database tables seem a bit messy? That's where database...
Mandatory Profile in Oracle Database
As you know, profiles can be used to impose restrictions on each user in two areas: resource...
Oracle 21c — Removal of IGNORECASE and SEC_CASE_SENSITIVE_LOGON Parameters
Starting from Oracle 21c, all passwords stored in the password file are case-sensitive. In previous...
Why n8n Become Popular in Oracle Cloud: Top Reasons Behind This Rapid Growth (2025 Guide)
If you've been exploring modern automation tools, you might have noticed that n8n become popular in...
Revolutionizing SQL Development with Oracle APEX AI Assistant
Oracle APEX 24.1 introduces the APEX AI Assistant, a transformative tool that enables developers to...
Chinese DBA's Story: Hu Zhonghao - The Journey of Becoming a DBA for Domestic Distributed Databases
On May 29th, the core system of a bank in Yunnan officially went live. Unlike the majority of banks...