Oracle PL-SQL Question:
What are the components of a PL/SQL block?
Answer:
A set of related declarations and procedural statements is called block.
DECLARE -- declaration section BEGIN -- executable statements -- main section EXCEPTION -- handling possible exceptions -- occuring in the main section END;
DECLARE -- declaration section BEGIN -- executable statements -- main section EXCEPTION -- handling possible exceptions -- occuring in the main section END;
| Previous Question | Next Question |
| What is the basic structure of PL/SQL? | What are the datatypes a available in PL/SQL? |