⟩ What are the modules in Power Mart?
1. PowerMart Designer
2. Server
3. Server Manager
4. Repository
5. Repository Manager
1. PowerMart Designer
2. Server
3. Server Manager
4. Repository
5. Repository Manager
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?
Explain how procedures and functions are called in a PL/SQL block?