MMMuhammad Mudassarinmudassardurvaish.hashnode.dev·May 3 · 2 min read🚀 Building an Audit Logging System in Oracle Autonomous Database using TriggersAs 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 cr00
MMMuhammad Mudassarinmudassardurvaish.hashnode.dev·May 2 · 2 min read🚀 Managing Transactions in Oracle SQL (COMMIT & ROLLBACK Explained with Real Example)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 eit00
MMMuhammad Mudassarinmudassardurvaish.hashnode.dev·May 1 · 2 min read🚀 Using Triggers in Oracle SQL (Automating Database Actions)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 events00
MMMuhammad Mudassarinmudassardurvaish.hashnode.dev·Apr 29 · 2 min read🚀 Using CASE Statements in Oracle SQL for Conditional LogicAs 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 data00
MMMuhammad Mudassarinmudassardurvaish.hashnode.dev·Apr 28 · 2 min read🚀 Understanding Constraints in Oracle SQL (PRIMARY KEY, NOT NULL, UNIQUE)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 00
