Search for a command to run...
Articles tagged with #oracle-database
Introduction PL/SQL (Procedural Language/Structured Query Language) is Oracle's procedural language that combines robust programming logic with direct database manipulation. Its flexibility enables the creation of stored procedures, functions, trigge...
📌 Introduction I decided to write this post about TOAD for Oracle after receiving a lot of positive feedback on previous posts about PL/SQL Developer and SQL Developer. The discussion around Oracle development tools sparked great insights, and it be...
Introduction In the realm of database management, task automation is crucial for optimizing operations, reducing human errors, and ensuring efficiency in production environments. Oracle Database provides powerful tools for this through the Oracle Sch...
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, ...
Whether you're setting up a local Oracle database or connecting to it via SQL Developer, this guide has you covered—from the official installer to resolving common connection errors like ORA-12541. 🔽 1. Downloading and Installing Oracle XE 🔗 Offic...
