Answer Posted / hr@tgksolutions.com
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 syntax?
how many tables will create when we create table, what are they? : Sql dba
What is fmtonly in sql?
What are the advantages of indexing?
how to get @@error and @@rowcount at the same time? : Sql dba
Can we use threading in pl/sql?
what is the difference between truncate and drop statements? : Sql dba
What is trigger in sql and its types?
How to avoid duplicate records in a query?
What is primary key and unique key?
Which sql statement is used to delete data from a database?
What is informix sql?
How can you create an empty table from an existing table?
What is the difference between cluster and non-cluster index?
Does pl/sql support create command?