What are the types PL/SQL code blocks?

What are the types PL/SQL code blocks?

Anonymous Block

- It is a block of codes without a name.
- It may contain a declaration part, an execution part, and exception handlers.

Stored Program Unit

- It is a block of codes with a name.
- It is similar to an anonymous block just that it can take parameters and return values.

Trigger

- It is a block of code that is implicitly fired based some specific event.
Advantages of PL/SQL
Advantages of PL/SQL - Support SQL data manipulation, Provide facilities like conditional checking, branching and looping...
What is a union, intersect, minus?
What is a union, intersect, minus? - Union operator is used to return all rows from multiple tables and eliminate duplicate rows...
Characteristics of function object
Characteristics of function object - A function can allow one or more or no parameter...
Post your comment