|
P325
– PROGRAMME ON PL / SQL (ORACLE 9i) (MODULE 2) (COMPANY
SPECIFIC PROGRAMME FOR L.I.C. OF INDIA) Background PL/SQL
is an application-development language that is a superset of SQL,
supplementing it with standard programming-language features that include:
block (modular) structure; flow-control statements and loops; variables,
constants, and types; structured data; customized error handling, etc. PL/SQL also allows us to store compiled code directly in the database. This enables any number of applications or users to share the same functions and procedures. In fact, once a given block of code is loaded into memory, any number of users can use the same copy of it simultaneously, which is useful for the Oracle WebServer. PL/SQL also enables us to define triggers, which are subprograms that the database executes automatically in response to specified events. Objectives After
completion of this programme, participants will be able to develop
business applications by using PL/SQL programming. Contents ·
Quick
revision of SQL*Plus ·
PL/SQL
Programming Concepts ·
Procedures ·
Cursors
·
Functions ·
Triggers ·
Packages Participants’ Profile Selected
AAO (Prog), AO, Asst. Secretary, Secretary and Manager of IT Department
from Central Office, Zonal Office, Divisional Office , Branch Office and
Training Centers Officers / Executives from other department and should
have the basic knowledge of Programming Note:
Completion / Knowledge of Module 1 (RDBMS basics & SQL) is essential. Duration:
4 days Dates:
03.09.2007 – 06.09.2007
|
|