What is the basic structure of PL/SQL?
Posted On: Feb 22, 2018
Answered by KanakThe basic structure of PL/SQL is the BLOCK structure. Every program of PL/SQL includes both the SQL statement and the PL/SQL statement, which eventually forms the PL/SQL block. Every PL/SQL block has three defined sections out of which two sections are optional i.e. the declaration section and the exception handling section and one section is mandatory i.e. the execution section.
1 Answer Written
Related Questions
Subscribe Our NewsLetter
Never Miss an Articles from us.
Recent Articles
Featured Categories
- Common Interview Questions
- Python Flask Interview Questions
- NoSQL Interview Questions
- jQuery Interview Questions
- C Programming Interview Questions
- AngularJs Interview Questions
- Node JS Interview Questions
- JavaScript Interview Questions
- Core Java Interview Questions
- HTML Interview Questions
- Laravel Interview Questions
- Wordpress Interview Questions
- PHP Interview Questions
PL/SQL Interview Questions
What is PL/SQL?
PL/SQL stands for Procedural Language extension of Structured Query Language (SQL). It is a block-structured language ha..
PL/SQL Interview Questions
Differentiate between PL/SQL and SQL?
PL/SQL is Oracle’s Procedural Language SQL which allows you to write full programs to execute options like insert/ sel..
PL/SQL Interview Questions
State few characteristics of PL/SQL?
Some of the characteristics of PL/SQL are furnished below: PL/SQL is completely portable as code can be executed on any ..