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
Want to speak to an Advisor about this course?
Students that were interested in this course also looked at...
See all

Important information

  • Course
  • Mumbai
  • 40 hours of class

Important information

Where and when

Starts Location
On request
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

Achievements for this centre

Students that were interested in this course also looked at...
See all