Oracle PL-SQL Question:
Download Job Interview Questions and Answers PDF
What is the basic structure of PL/SQL?
Answers:
Answer #1PL/SQL uses block structure as its basic structure. Anonymous blocks or nested blocks can be used in PL/SQL.
Answer #2PL/SQL support block structure. such as
1) Anonymous block
2) Named block and
3) Sub program <This also fall into blocks>
1) Anonymous block
2) Named block and
3) Sub program <This also fall into blocks>
Download Oracle PL-SQL Interview Questions And Answers
PDF
Previous Question | Next Question |
If the application is running very slow? At what points you need to go about the database in order to improve the performance? | What are the components of a PL/SQL block? |