Over

155,000

Africa & Middle East

7Days 10.00 A.M - 10.00 P.M

Call us

Enquire Now



Technology is constantly changing and Oracle has been keeping pace with multiple new technologies. Oracle is the choice of most successful companies and enterprises due to its products, solutions and security options. It offers solutions for every role in the enterprise. We at ITShare , in collaboration with passionate technology experts offers Oracle training on varied products/applications for every role in the enterprise. They'll let you deep dive into core concepts, taking you through real-world scenarios and applications. This also builds your confidence in preparing for Oracle certifications. Enroll for the right Oracle course and get access to details on different products including Java and Middleware, Database, Applications, Business Intelligence (BI), Enterprise Management, loud and more from Oracle technology network.

Oracle Database 12c: Program with PL/SQL – (Official)


by pallvi
Free
0 Lessons
0 Students

Overview

Oracle Database 12c R2: Program with PL/SQL Ed 2 training course is designed to introduce about PL/SQL and then explores the benefits of this powerful programming language. In this training class, you’ll learn to develop stored procedures, functions, packages and more.

Target Audience:
  • Application Developers
  • Database Administrators
  • Developer
  • Forms Developer
  • PL/SQL Developer
  • Portal Developer
  • System Analysts
  • Technical Consultant


This course prepares you for Exam 1Z0-144. Download Course Contents

  • Manage dependencies between PL/SQL subprograms
  • Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors)
  • Create stored procedures and functions
  • Use conditional compilation to customize the functionality in a PL/SQL application without removing any source code
  • Use the Oracle supplied PL/SQL packages to generate screen output, file output and mail output
  • Write dynamic SQL for more coding flexibility
  • Create overloaded package subprograms for more flexibility
  • Create triggers to solve business challenges
  • Create and debug stored procedures and functions
  • Describe the features and syntax of PL/SQL
  • Design PL/SQL anonymous blocks that execute efficiently
  • Design PL/SQL packages to group related constructs
  • Handle runtime errors

Lessons

APPLY TO COURSE

Sum the simple Operation :
8 + 14 =