Related InterviewSolutions

• What is the difference between implicit and explicit cursors?
• Which command is used to delete a package?
• How do you refer to the types, objects and subprograms declared within a package?
• Which command(s) are used for creating PL/SQL packages?
• PL/SQL packages usually have two parts. What are these two parts?
• What are the steps that need to be performed to use an explicit cursor? Discuss briefly.
• What do you understand by explicit cursors?
• How do you declare a user-defined exception?
• What is the difference between a function and a stored procedure?
• Which command is used to delete a procedure?