Answer Posted / glibwaresoftsolutions
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
Can you skip header records while loading? : aql loader
how to create a new table in mysql? : Sql dba
How many types of literals are available in pl sql?
Can pl sql procedure have a return statement?
Does sql*plus also have a pl/sql engine?
How many tables can you join in sql?
How do I create an index in word?
How to revise and re-run the last sql command?
Can we call dml statement in function?
Define commit, rollback and savepoint?
What operating systems are supported by oracle sql developer?
Can we commit inside a trigger?
What is the difference between local variables and global variables?
How many types of triggers exist in pl/sql?
What is form and report?