+ 1
What are triggers and cursors in SQL?
are they used in front ends ?
2 odpowiedzi
+ 3
A trigger it's an automatic SP(storedprocedure) that happens when some specific situation happens.
A cursor works pretty much like an array, wich let us read row per row, and also modifiy the data.
Data Bases related are back-end stuff. How you show (style, grouped, colors) are front end.
+ 1
cursor:
A cursor is a pointer to this context area. PL/SQL controls the context area through a cursor. A cursor holds the rows (one or more) returned by a SQL statement.
Trigger:
A trigger is a special kind of stored procedure that automatically executes when an event occurs in the database server. DML triggers execute when a user tries to modify data through a data manipulation language (DML) event. DML events are INSERT, UPDATE, or DELETE statements on a table or view