Search for a command to run...
Articles tagged with #sqltutorial
Introduction PL/SQL (Procedural Language/Structured Query Language) is a procedural extension of SQL developed by Oracle for working with relational databases. It enables the creation of code blocks that combine SQL commands with programming construc...
A complete guide with setup, practical examples, and advanced tips
Native JSON support in Oracle 12c and 19c has brought a new dimension to PL/SQL development. You can now manipulate structured JSON data directly within the database — without relying on external tools or complex conversions. In this guide, you'll le...
📌 Introduction With the rise of REST APIs and data exchange in JSON format, PL/SQL developers face the challenge of handling JSON in Oracle environments that lack native support. While Oracle 19c and newer versions include types like JSON_OBJECT_T, ...
