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
Explain how can you save or place your msg in a table?
What is the difference between syntax error and runtime error?
How do I truncate a sql log file?
What is a join?
What is index example?
Can a view be mutating? If yes, then how?
What is the use of index in hive?
Is clustered index a primary key?
Is it mandatory for the primary key to be given a value when a new record is inserted?
How does an execution block start and end in pl sql?
explain commit and rollback in mysql : sql dba
Which is faster count (*) or count 1?
How many sql are there?
How to rename a column in the output of sql query?
Where is pl sql used?