Diff. Between Function and procedure, trigger, cursor and it's type, use of cursor in PL/SQL.

Question

Accepted Answer

Explanation of Function, Procedure, Trigger, Cursor and its types, and the use of Cursor in PL/SQL.

Function is a subprogram that returns a value while a Procedure is a subprogram that does not return a value.
Trigger is a special type of stored procedure that is automatically executed in response to certain events.
Cursor is a database object that allows you to manipulate data row by row.
There are two types of Cursor: Implicit and Explicit.
Implicit Cursor is used by default when executing SQL statements while Explicit Cursor is defined by the programmer.
Cursor is used in PL/SQL to fetch data from a table and process it row by row.
Example of Cursor: DECLARE CURSOR c1 IS SELECT * FROM employees;
The use of Cursor in PL/SQL involves opening the Cursor, fetching data, processing data, and closing the Cursor.

Popular interview questions of Associate Technical Consultant