Course in Oracle 9i: Programme with PL/SQL (Paper 2)

Aptech Computer Education
In Mumbai

Price on request
You can also call the Study Centre
22657... More
Compare this course with other similar courses
See all

Important information

  • Course
  • Mumbai
  • 40 hours of class
Description

Important information
Venues

Where and when

Starts Location
On request
Mumbai
A-302, Vertex Vikas Building Above A to Z Jumbo Zerox Opp. Andheri Railway Station M.V.Road Andheri (East) , 400069, Maharashtra, India
See map

Frequent Asked Questions

· Requirements

Eligibility:- Prior knowledge of SQL, and iSQL*Plus is necessary.

Course programme

Procedural Language/SQL (PL/SQL) extends SQL by adding constructs found in procedural languages, resulting in a structural language that is more powerful than SQL. This paper introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. By the end of this segment, students will be able to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. The students will also learn to create procedures, functions, packages, and database triggers.

After the completion of this course, the student will be able to:

* Describe the features and syntax of PL/SQL
* Explain writing executable statements
* Explain the control structures
* Describe and use composite data types
* Explain the process of writing explicit cursors
* Describe subprogrammes
* Describe the use of functions
* Describe packages in PL/SQL
* List and explain Oracle server-supplied packages
* Describe triggers

Compare this course with other similar courses
See all