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
Is it possible to read/write files to-and-from PL/SQL?
What are stored procedures used for?
what are different types of collation sensitivity? : Sql dba
how to show all tables with 'mysql'? : Sql dba
Is json a nosql?
Sql technical questions
How would you pass hints to the sql processor?
Are left and right joins the same?
How do you remove duplicates without using distinct in sql?
Explain the update statement in sql
Can you rollback after commit?
What are inbuilt functions in sql?
Why coalesce is used in sql?
Can there be 2 primary keys in a table?
What does subquery mean in sql?