⟩ What are active transformation / Passive transformations?
Active transformation can change the number of rows that pass through it. (decrease or increase rows)
Passive transformation can not change the number of rows that pass through it.
Active transformation can change the number of rows that pass through it. (decrease or increase rows)
Passive transformation can not change the number of rows that pass through it.
What are the PL/SQL Statements used in cursor processing?
Explain the two type of Cursors?
What is a cursor ? Why Cursor is required?
What is PL/SQL table?
What is difference between a PROCEDURE & FUNCTION?
What are advantages fo Stored Procedures?
What are the modes of parameters that can be passed to a procedure?
What are the two parts of a procedure?
Give the structure of the procedure?
Give the structure of the function?