|
P325 – PROGRAMME ON PL / SQL (ORACLE 10g) (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: Knowledge RDBMS basics & SQL is essential. Duration: 4
days Dates:
01.09.2008 - 04.09.2008 |
|