+ 1

What are triggers and cursors in SQL?

are they used in front ends ?

8th Dec 2016, 2:33 AM
Ahamad Irfan
Ahamad Irfan - avatar
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.
8th Dec 2016, 2:38 AM
Nahuel
Nahuel - avatar
+ 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
10th Jul 2017, 12:02 PM
s keerthana
s keerthana - avatar