PL/SQL
In-depth Oracle PL/SQL development guides and best practices. Learn how to architect robust packages, procedures, and functions, leverage bulk collect and FORALL for massive data processing, optimize cursors, implement advanced exception handling, design complex collections and records, and secure your enterprise database logic.
Native JSON Processing in PL/SQL: The Modern Oracle Guide
Learn how to natively parse, generate, and query JSON data directly inside Oracle PL/SQL. Master JSON_OBJECT, JSON_ARRAY, JSON_TABLE, and dot-notation for modern REST API integrations.
PL/SQL Triggers: The Complete Guide (And How to Avoid ORA-04091)
A comprehensive deep dive into Oracle PL/SQL Triggers. Understand DML and DDL triggers, Statement vs. Row-level scoping, the dreaded Mutating Table error (ORA-04091), and how to elegantly solve it using modern Compound Triggers.
PL/SQL Masterclass: Collections & Bulk Processing
Master Oracle PL/SQL Collections (Associative Arrays, Nested Tables, VARRAYs) and learn how to use BULK COLLECT and FORALL for massive performance gains.
PL/SQL Masterclass: Building REST APIs in PL/SQL (ORDS)
Turn your Oracle Database into a modern web server. Learn how to use Oracle REST Data Services (ORDS) to expose PL/SQL procedures as secure, JSON-based RESTful APIs.
PL/SQL Masterclass: Working with Large Objects (DBMS_LOB)
Master Oracle LOBs. Learn how to store, slice, search, and manipulate massive character (CLOB) and binary (BLOB) data using the DBMS_LOB package.
PL/SQL Dynamic SQL Mastery: EXECUTE IMMEDIATE vs DBMS_SQL
Master Dynamic SQL in Oracle PL/SQL. Learn when to use native EXECUTE IMMEDIATE versus the advanced DBMS_SQL package, how to handle bind variables safely, execute DDL dynamically, and prevent SQL Injection.
PL/SQL Masterclass: Pipelined Table Functions for ETL
Master Oracle Pipelined Table Functions. Learn how to return rows iteratively using PIPE ROW, eliminate memory overhead in ETL processes, and build dynamic data transformations.
PL/SQL Masterclass: Advanced Job Scheduling with DBMS_SCHEDULER
Move beyond basic database jobs. Master DBMS_SCHEDULER to create complex job chains, event-based schedules, and automated maintenance tasks in Oracle.
PL/SQL Masterclass: Object-Oriented PL/SQL
Bring Object-Oriented Programming (OOP) to your Oracle Database. Learn how to create custom Object Types, Constructors, Methods, and Inheritance in PL/SQL.
Explore Other Hubs
RC:OMS
Multi-channel order management with double-entry inventory ledger. Amazon, Flipkart, Shopify, WooCommerce — one source of truth.
Launch demo →RC:Storefront
Self-hosted headless e-commerce. Your server, your data, zero transaction fees. Native RC:OMS inventory sync.
Visit Storefront →RC:Pulse
AI-powered retail analytics and demand forecasting — built natively on top of your RC:OMS and Storefront data.
Request early access →