DBMS Transaction Management: Introduction (ACID properties )
DBMS Transaction Management: Introduction (ACID properties ) Introduction · A database transaction: - · A set of logically related operation Involve in one or more database access operation. · Contains a group of tasks. · Represent real-world events of any enterprise. · All database operation held between the…
Read more
PL/SQL Trigger
PL/SQL Trigger Triggers are stored programs, which are automatically executed or fired when some events occur. Triggers are executed in response to any of the following events − · A database manipulation (DML) statement (DELETE, INSERT, or UPDATE) · A database definition (DDL) statement (CREATE, ALTER, or DROP). · A d…
Read more
PL/SQL Cursor
PL/SQL Cursor SQL statement processed in a memory area known as context area. The context area is controlled by the cursor. A cursor is a pointer. It contains all information about processing statements such as select statements and accessed the rows data. The set of rows that are held by the cursor at a time is known as the active set . …
Read more
Social Plugin