Answer Posted / nashiinformaticssolutions
Yes, the basic structure of a PL/SQL block includes:
• Declaration section: Where you define variables, constants, and cursors.
• Execution section: Where you write the actual PL/SQL code, including SQL statements and procedural logic.
• Exception handling section: Where you handle errors and exceptions that may occur during execution.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are different types of keys in sql?
What is database migration?
What is a string data type in sql?
What view means?
What are different clauses used in sql?
What are types of indexes in sql?
What is AUTH_ID and AUTH_USER in pl/sql ?
How to get list of all tables from a database?
how to convert character strings to dates? : Sql dba
Explain ttitle and btitle.
What packages are available to pl/sql developers?
How do sql databases work?
Explain exception handling in pl/sql?
Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?
How are functions and procedures called in PL/SQL?