1.

Explain the basic structure followed in PL/SQL?

Answer»
  • The basic structure of PL/SQL follows the BLOCK structure. Each PL/SQL code comprises SQL and PL/SQL statement that CONSTITUTES a PL/SQL block.
  • Each PL/SQL block consists of 3 sections:
    • The optional Declaration Section
    • The mandatory EXECUTION Section
    • The optional Exception handling Section
[DECLARE]--declaration statements (optional)BEGIN--execution statements[EXCEPTION]--exception handling statements (optional)END;


Discussion

No Comment Found

Related InterviewSolutions