1.

Why do we use Rowtype in PL SQL?

Answer»

In PL/SQL, Rowtype is used to PROVIDE a RECORD type/data type in the form of ROWS in a database. Variables declared using the %ROWTYPE attribute are CONSIDERED to be declared using a data type name.

4. How many types of triggers are there in PL SQL?

In PL/SQL, there are two types of triggers:

  • Row level triggers: Used to trigger an event once any changes are MADE in rows.
  • Statement level trigger: It is used to trigger an event for each executed SQL statement.


Discussion

No Comment Found

Related InterviewSolutions