Page no:55
Sr. No. 15
Topic Report writer using SQL Title, Btitle, skip, pause, column, SQL, Break on, computer sum Introduction of PL/SQL Advantages of PL/SQL Support of SQL Executing PL/SQL PL/SQL character set & Data Types Character, row, rowed, Boolean, binary integer, number Variable, constant PL/SQL blocks Attribute % type, %rowtype, operators, function comparison numeric, character, date Control structure Condition – if Interactive- loop, for, while Sequential – goto Composite data types Record- declaration, refer, record assignment Table- Declaration, table attributes (Count, delete, exists, first, last, next, prior) Database Triggers Definition, syntax, parts of triggers Types of triggers, enabling & disabling triggers Sub programs Definition Features Cursors Procedures Definition, creating, Parameter Function Definition & implementation Total sessions: 40
16
17
18
19
20
21
22 23
Recommended Books: 1. Understanding ORACLE Perry J. & Later J. 2. Understanding SQL Martin Gruber, BPB publication 3. SQL Scott Urman 4. ORACLE PL/S E0?A?????????M????U??????ME0??A0?ME0?????????????????????????=?????%??? ?????((0