Explain block structure of PL/SQL

Explain block structure of PL/SQL.



The order of the parts is quite logical:

- First comes the declarative part, in which items can be declared.
- Items can be manipulated in the executable part.
- Exceptions raised during can be handled in the exception-handling part
Write a PL/SQL program for a trigger
PL/SQL program for a trigger - PL/SQL program for tracking operation on a emp table...
What are SQLCODE and SQLERRM? Why are they important for PL/SQL developers?
SQLCODE: It returns the error number for the last encountered error. SQLERRM:...
Difference between SQL and PL/SQL
SQL is Structured Query Language comprising of Data Definition Language (DDL) and Data Manipulation Language (DML)...
Post your comment