Oracle systems today rely heavily on PL/SQL to provide support for many types of applications. PL/SQL modules written in the form of stored procedures, functions packages and embedded anonymous blocks, allow critical business logic to be stored in the database server and made available to many forms of client requests.
declaring variables ( including. use of %TYPE %ROWTYPE, SUBTYPE, TYPE) Constant, NOT NULL, DEFAULT etc.
Assignment, IF/THEN/ELSE/ELSIF, CASE, LOOP , WHILE, FOR, NULL; GOTO
Choose extra topics from:
Where a site has a particular PL/SQL approach or technique that is commonly used by staff, then we will try to include where possible
This course provides a series of progressive and thoughtful exercises to reinforce course teaching. Exercises range from Try-This-Now quick work to longer, more thoughtful approaches. Typically, course content is organised so that for nearly every hour of the course, delegates have an exercise to do
declaring variables ( including. use of %TYPE %ROWTYPE, SUBTYPE, TYPE) Constant, NOT NULL, DEFAULT etc.
Assignment, IF/THEN/ELSE/ELSIF, CASE, LOOP , WHILE, FOR, NULL; GOTO
Choose extra topics from:
Where a site has a particular PL/SQL approach or technique that is commonly used by staff, then we will try to include where possible
This course provides a series of progressive and thoughtful exercises to reinforce course teaching. Exercises range from Try-This-Now quick work to longer, more thoughtful approaches. Typically, course content is organised so that for nearly every hour of the course, delegates have an exercise to do
Oracle application developers, script writers, designers, database administrators and support staff who already use SQL, and who need to know more to be effective with Oracle!
Delegates must be familiar with
1) their underlying operating system (typically Windows or UNIX)
2) Already have basic programming skills
3) A working knowledge of SQL
Receive Tech Updates directly to your inbox
CONTACT
+44 (0)20 8446 7555
enquiries@jbinternational.co.uk
Corporate Policies Terms & Conditions
JB International Training Ltd - Company number 08458005
Registered address Wohl Enterprise Hub 2B Redbourne Avenue London N3 2BS
POPULAR
AI & ML training course React training course
Threat modelling training course Python for data analysts training course
Power BI training course Machine Learning training course
Spring Boot Microservices training course Terraform training course