DEV Community

Cover image for Cursor +Trigger
DEEPAK KUMAR B 24CB007
DEEPAK KUMAR B 24CB007

Posted on

Cursor +Trigger

In SQL, sometimes you need more than just basic queries.
What if you want to process each row individually?
Or automatically record every change happening in your table?

That’s where Cursors and Triggers come in.

Let’s walk through both with clear examples, outputs, and real-world use cases!

A Cursor in SQL works like a pointer that allows you to process rows one by one from a query result.
It’s useful when you need conditional logic or procedural control inside your SQL block.

A Trigger is like a background assistant that automatically executes when a specific event occurs. For example, when someone inserts, updates, or deletes data.

Cursor Example
Create a table


Insert the values

Output

Cursor Code (Employees with Salary > 50,000)

Trigger Example (AFTER INSERT Trigger)

Create table Student_Audit


Create AFTER INSERT Trigger

Insert Data into table and get output

SUMMARY
1.Cursors allow row-by-row processing of query results.
2.Triggers automate actions on data changes (here, logging inserts).
Both Cursors and Triggers bring life to SQL databases.
:Use Cursors when you need fine-grained control.
:Use Triggers to automate repetitive monitoring or logging.

Top comments (0)