All Articles

Tag: Oracle Database

22 articles found

PL/SQL Masterclass: Object-Oriented PL/SQL
Development Guide
25 min read

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.

Read Article
PL/SQL Masterclass: Oracle Advanced Queuing (AQ) Architecture
Architecture Guide
25 min read

PL/SQL Masterclass: Oracle Advanced Queuing (AQ) Architecture

Build robust, asynchronous, event-driven architectures natively within Oracle using Advanced Queuing (AQ). Learn how to enqueue, dequeue, and trigger events.

Read Article
PL/SQL Masterclass: Security & SQL Injection Prevention
Security Guide
25 min read

PL/SQL Masterclass: Security & SQL Injection Prevention

Protect your Oracle Database from malicious attacks. Learn how to prevent SQL Injection in dynamic PL/SQL, implement DBMS_CRYPTO, and manage Invoker vs Definer rights.

Read Article
PL/SQL Performance Tuning: Beyond the Basics
Performance Guide
30 min read

PL/SQL Performance Tuning: Beyond the Basics

Master PL/SQL performance tuning. Learn how to minimize Context Switches, utilize the RESULT_CACHE, and write highly optimized loops.

Read Article
PL/SQL Masterclass: Error Handling & Application Logging
Development Guide
25 min read

PL/SQL Masterclass: Error Handling & Application Logging

Master PL/SQL Exception Handling. Learn how to trap ZERO_DIVIDE, handle NO_DATA_FOUND, define custom PRAGMA EXCEPTION_INIT, and build autonomous logging.

Read Article
PL/SQL Complete Guide: From Basics to Advanced
Complete Guide
38 min read

PL/SQL Complete Guide: From Basics to Advanced

The definitive PL/SQL reference for Oracle developers — covering PL/SQL block structure, variables and data types (%TYPE, %ROWTYPE), conditional statements (IF/CASE), all loop types, implicit and explicit cursors, exception handling (predefined & user-defined), stored procedures vs functions, packages (spec & body), triggers (BEFORE/AFTER/INSTEAD OF), BULK COLLECT & FORALL for performance, and EXECUTE IMMEDIATE dynamic SQL. Real-world Oracle Retail examples throughout.

Read Article
SQL Masterclass: Mastering the Oracle Data Dictionary
Administration Guide
22 min read

SQL Masterclass: Mastering the Oracle Data Dictionary

Learn how to query Oracle's metadata using ALL_, DBA_, and V$ views. Discover how to dynamically generate scripts and troubleshoot database performance.

Read Article
SQL Masterclass: Table Partitioning Strategies for VLDB
Administration Guide
28 min read

SQL Masterclass: Table Partitioning Strategies for VLDB

Master Oracle Table Partitioning for Very Large Databases (VLDB). Learn Range, Hash, and List partitioning strategies to enable partition pruning and dramatically accelerate queries.

Read Article
SQL Masterclass: Materialized Views & Query Rewrite
Performance Guide
24 min read

SQL Masterclass: Materialized Views & Query Rewrite

Accelerate your data warehouse dashboards using Oracle Materialized Views. Learn about Fast Refresh, ON COMMIT refreshes, and how to configure Query Rewrite to intercept and speed up user queries automatically.

Read Article
RetailCoder
All systems operational
v1.0 Live

RC:OMS

Multi-channel order management with double-entry inventory ledger. Amazon, Flipkart, Shopify, WooCommerce — one source of truth.

Launch demo →
v1.0 Live

RC:Storefront

Self-hosted headless e-commerce. Your server, your data, zero transaction fees. Native RC:OMS inventory sync.

Visit Storefront →
Pipeline

RC:Pulse

AI-powered retail analytics and demand forecasting — built natively on top of your RC:OMS and Storefront data.

Request early access →
Built in India 🇮🇳  ·  Architected by Priyanshu PandeyTalk to an engineer →