(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 ...