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 collation? : Sql dba
what is sql server agent? : Sql dba
how to start mysql server? : Sql dba
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
Is primary key always clustered index?
what is bcp? When does it used? : Sql dba
what are all the common sql function? : Sql dba
If a cursor is open, how can we find in a pl/sql block?
Can we rollback truncate?
What is the current version of postgresql?
What is the current version of sql?
Do we need to rebuild index after truncate?
how to use regular expression in pattern match conditions? : Sql dba
Is primary key clustered index?
what are the advantages of sql ? : Sql dba
