Basic Oracle Concepts and Programming Question: Download Questions PDF
What Are the Types PL/SQL Code Blocks?
Answer:
There are 3 types of PL/SQL code blocks:
► Anonymous Block - A block of codes with no name. It may contain a declaration part, an execution part, and exception handlers.
► Stored Program Unit - A block of codes with a name. It is similar to an anonymous block. But it can take parameters and return values.
► Trigger - A block of code that can be defined to fire based an specific event.
► Anonymous Block - A block of codes with no name. It may contain a declaration part, an execution part, and exception handlers.
► Stored Program Unit - A block of codes with a name. It is similar to an anonymous block. But it can take parameters and return values.
► Trigger - A block of code that can be defined to fire based an specific event.
Download Oracle Database Interview Questions And Answers
PDF
Previous Question | Next Question |
What Is PL/SQL? | How To Define an Anonymous Block? |