Introduction to Oracle9i: PL/SQL Language Professional Training Solutions Ltd

Price: TBA

Location: Westland Square Pearse St Dublin 2 Ireland
Duration: 2 Days
Call: +971 4 5490356

Course details

The Oracle PL/SQL language provides for programming logic features not contained within SQL. The grammar, syntax and benefits of using the PL/SQL language within an Oracle database environment are considered. At Course Completion The primary objective of this course is to provide an introduction to the PL/SQL database programming language. Major subject areas to be explored are: Declaring variables and complex datatypes. Developing logic within PL/SQL program blocks. Fetching data from the database into program variables. Returning program output to users. Handling program exceptions. Using explicit and implicit database cursors. Using the advanced features of nested blocks and subprograms.

Prerequisites:

Mandatory Prerequisites: Introduction to Oracle9i: SQL and Introduction to Oracle9i: Advanced SQL

LANGUAGE FEATURES:

why use pl/sql?
where pl/sql program units may be deployed
the java alternative to pl/sql
structure of a pl/sql program block
pl/sql from interactive tools
generating output

DECLARE CLAUSE:

datatypes
declare example
special datatypes
%type variable
%rowtype record
type table

BEGIN CLAUSE:

data manipulation
char and varchar
numeric
date
boolean
comparison operators
functions
date calculations
selectinto
logic control & branching
goto
loop
if-then-else
case

EXCEPTION:

handling exception
special features
system defined exceptions
using sqlcode & sqlerrm
implicit cursors
user-defined ex_ined
pragma exception_init

EXPLICIT CURSORS:

understanding cursors
explaining the cursor example
declare cursor e
open cursor example
fetch cursor example
close cursor example
including cursor parameters
performing updates from cursors
using forloop cursors

ADVANCED:

using nested blocks
using declared subprograms
display_message() procedure example
get_spouse_name() function example

Updated on 08 November, 2015

Course Location

Show map Location Westland Square Pearse St Dublin 2 Ireland

About Professional Training Solutions Ltd

Professional Training is a group of experienced specialists providing specific training and consultancy solutions, within Management Skills, I.T. systems, Human Restheirce Development, Credit Management, Sales, Finance and Engineering.

they believe in using a combination of tailored, flexible approaches and real-life business knowledge to develop and provide techniques and solutions for immediate implementation.

their recent projects include supporting major initiatives for clients in utilities, telecoms, manufacturing and software, covering:

restructuring for competitiveness

productivity improvements through updating work processes to match new technology

managing outstheircing

strategic financial planning and engineering

their methodology is to:

Work closely with clients to understand and help them prioritise their needs

Design and deliver the best mix of training activities and consultancy to establish the competencies required

Provide ongoing coaching to sustain the improved practices and processes

they create relevant, targeted, enjoyable, and interactive, training sessions which are designed to improve the retention of information by participants and create a clear link from the training to the workplace. This creates a planned, visible improvement in key business indicators such as productivity, motivation, loyalty, employee retention, and ultimately, profit.

their collaborative approach builds long-term relationships with clients. Together, they can deal effectively with the inevitable challenges all businesses face.

See all Professional Training Solutions Ltd courses

View more Virtual classroom training for Oracle online courses See all Oracle Courses

See all current SQL Server and Oracle jobs in UAE