@mudassardurvaish

🚀 Building an Audit Logging System in Oracle Autonomous Database using Triggers

May 3 · 2 min read · As part of my hands-on learning with Oracle Autonomous Database on Oracle Cloud Infrastructure (OCI), I explored how to implement an audit logging system using database triggers. Audit logging is a cr

🚀 Managing Transactions in Oracle SQL (COMMIT & ROLLBACK Explained with Real Example)

May 2 · 2 min read · While working with Oracle Autonomous Database, I explored how transactions work and why they are critical in real-world applications like banking systems. In many systems, multiple operations must eit

🚀 Using Triggers in Oracle SQL (Automating Database Actions)

May 1 · 2 min read · As part of my continued learning with Oracle Autonomous Database, I explored how triggers can be used to automate database actions. Triggers allow us to automatically execute logic when certain events

🚀 Using CASE Statements in Oracle SQL for Conditional Logic

Apr 29 · 2 min read · As part of my continued learning with Oracle Autonomous Database, I explored how to use CASE statements in SQL. CASE statements allow us to apply conditional logic directly within queries, making data

🚀 Understanding Constraints in Oracle SQL (PRIMARY KEY, NOT NULL, UNIQUE)

Apr 28 · 2 min read · As part of my continued learning with Oracle Autonomous Database, I explored constraints in SQL. Constraints are rules applied to table columns to ensure data accuracy and integrity. 🎯 Objective The