Dynamic SQL

Dynamic SQL  refers to the practice of executing SQL statements  dynamically at…

Transaction Controls and Exception Handlings

When developing a database application using PL/SQL, errors are common. There a…

Cursors

Previously, we discussed implicit cursors and their attributes. These cursors a…

Embedding SQL Statements for CRUD Operations

Create, Read, Update,  and  Delete (CRUD)  are the four essential functionaliti…

Creating and Using Views for CRUD Operations

Complex SQL Queries: PIVOT and CONNECT BY

For those already familiar with SQL and basic query writing, the next step is m…