WORKING WITH EXCEPTIONS IN PL/SQL
WORKING WITH EXCEPTIONS IN PL/SQL: ================================= EXCEPTIONS: a) It is an IDENTIFIER in PL/SQL, raised during t......
13 Years Ago
CURSOR WITH SUBQURIES
CURSOR WITH SUBQURIES: a) A CURSOR can be constructed upon the result provided through a SUBQUERY. b) The SUBQUERY can be an o......
13 Years Ago
DATA MANIPULATING THROUGH PL/SQL
DATA MANIPULATING THROUGH PL/SQL: a) The data in the database is manipulated using the DML Commands. b) The DML Commands ......
13 Years Ago
PL/SQL TABLES
PL/SQL TABLES: a) Objects of type TABLE are called PL/SQL tables. b) They are modeled as database tables, but are not sa......
13 Years Ago
%ROWTYPE ATTRIBUTE
%ROWTYPE ATTRIBUTE: a) To declare a record based on a collection of columns in a database table or view, we can use the %ROWTYPE a......
13 Years Ago
DEFINING and DECLARING A PL/SQL RECORD
DEFINING and DECLARING A PL/SQL RECORD: a) To create a Recoed, we define a RECORD type and then declare Records of that Type. ......
13 Years Ago