Oracle PL/SQL Procedures
1. Introduction to PL/SQL Procedures A Procedure in Oracle PL/SQL is a named program unit that performs a specific action. […]
Oracle SQL
Oracle PLSQL
Oracle PL/SQL Next Level: Real-World Practice on Procedures & Functions
If you’ve reached this post — congratulations 🎉You’ve already crossed the basics of PL/SQL and database interaction. Now comes the
Oracle PLSQL
PLSQL Practice Set 1
Refer the Sample Schema for this practice- https://blog.otlms.in/oracle-pl-sql-practice-reference-table-schemas-for-real-world-use-cases/ This practice set is designed to push your thinking beyond syntax and
Oracle PLSQL
Oracle PL/SQL Practice – Reference Table Schemas for Real-World Use Cases
🏦 1. BANK_CUSTOMERS Stores core customer details for banking and fintech systems. 💰 2. BANK_ACCOUNTS Maintains account-level details including balances.
Oracle SQL
Analytical Functions in Oracle 19c – A Complete, Practical Guide
Introduction Analytical (also called analytic or window) functions are one of the most powerful features of the Oracle database. They
Oracle SQL
SQL MERGE Statement
Problem: Table: CUSTOMER_FIN Table: CUSTOMER_RAW Use of MERGE Statement and insert new records. Syntax MERGE INTO table_name– specify the target
Oracle SQL
Demo of SQL CASE Statement
Problem: Required: The SQL CASE statement allows you to perform IF-THEN-ELSE functionality within an SQL statement. It’s good for displaying
Oracle SQL
Subquery in Oracle
A subquery is a query nested inside another query, typically used to perform more complex searches by querying results from
Oracle SQL
Practice Character, Date & Numeric Functions (Banking & FinTech)
📖 Introduction In Banking and FinTech applications, Oracle SQL functions are used daily for: This blog provides a complete hands-on
Oracle DBA
Oracle Database Links (DB Links) – Complete Guide with Examples, Lab & Quiz
Introduction In real-world enterprise systems, data is rarely stored in a single database.Applications often need to read or write data