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 is int identity in sql?
what is the difference between primary key and unique key? : Sql dba
What is delimiter sql?
Explain scalar functions in sql?
Is pl sql and postgresql same?
Can you sum a count in sql?
What are primary key and foreign key and how they work?
What has stored procedures in sql?
What is substitution variable in pl sql?
What is pl/sql language case sensitive?
What is file based approach?
how to extract a unit value from a date and time? : Sql dba
What is procedure and function in sql?
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
How many commands are there in sql?