(E-Book) Class XII Informatics Practices : Chapter - III (Tables And Exception Propagation)

Disclaimer: This website is NOT associated with CBSE, for official website of CBSE visit - www.cbse.gov.in

Chapter – II

Tables And Exception Propagation

(Informatics Practices)


PL/SQl TABLEs combine characteristics of SQL tables and C/Pascal arrays.
Like SQL tables:

  • consist of records (must have a numeric primary key)
  • can grow/shrink as elements are added/removed

Exceptions

An exception is an unusual/erroneous condition encountered during execution:

  • system error (e.g. "out of memory")
  • error caused by user program
  • warning issued by application

PL/SQL's exception handling allows these to be handled "cleanly" in a central place.

Syntax for exception handlers:
     BEGIN
          ... Statements ...