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
What is query optimization in sql?
What are the types of optimization?
What are the features of pl sql?
How are sql commands classified?
what is oracle database ? : Sql dba
what are the types of subquery? : Sql dba
What does the base_object_type column shows in the user.triggers data dictionary view?
How do I run a sql query?
Can we call a function containing dml statements in a select query?
What is asqueryable?
What is function and procedure?
How does a trigger work?
what is sql profiler? : Sql dba
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
Can we use rowid as primary key?