تفاصيل الدورة

This course starts with an introduction to PL/SQL and proceeds to list the benefits of this powerful programming language. Participants are made aware of how to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. In addition, creation of anonymous PL/SQL blocks as well as stored procedures and functions are covered in this course.

Participants enhance their developer skills by learning to develop, execute, and manage PL\SQL stored program units such as procedures, functions, packages, and database triggers. Understanding the basic functionality of how to debug functions and procedures using the SQL Developer Debugger gives way to refined lines of code. Participants also learn to manage PL/SQL subprograms, triggers, declaring identifiers, and trapping exceptions. The utilization of some of the Oracle-supplied packages is also in the course. Additionally participants learn to use Dynamic SQL, understand design considerations when coding using PL/SQL, understand and influence the PL/SQL compiler, and manage dependencies. This course is the bundle of Oracle Database: PL/SQL Fundamentals and Oracle Database: Develop PL/SQL Program Units courses.

Students use Oracle SQL Developer to develop these program units. SQL*Plus and JDeveloper are introduced as optional tools.

This is appropriate for a 10g and 11g audience. There are minor changes between 10g and 11g features.Learn To:

  • Conditionally control code flow (loops, control structures)
  • Use PL/SQL packages to group and contain related constructs
  • Create triggers to solve business challenges
  • Use some of the Oracle supplied PL/SQL packages to generate screen output and file output
  • Create anonymous PL/SQL blocks, functions, and procedures
  • Declare PL/SQL Variables
تحديث بتاريخ 08 November, 2015

نبذة عن معهد New Horizons Singapore

Whether the training is for one individual or several hundred employees in multiple locations across the globe, New Horizons has a training program to fit any company or any individual need. We deliver a full range of technical, application and business skills training solutions. Our training ranges from basic application and desktop productivity tools (i.e., Project, Excel, PowerPoint) to complex and integrated business systems (i.e., information security, ITIL, Microsoft, Cisco and Novell). New Horizons offers classroom, mentored and distance learning options for virtually every desktop application used in the world of business

عرض الجميع دورات New Horizons Singapore
Are you from New Horizons Singapore ? Claim your course!
دورات يمكنك الالتحاق بها على الفور... خذ دورة عبر الإنترنت على Oracle ابتداءً من الآن. See all courses

هل هذه الدورة التدريبية الاختيار المناسب لك؟

قيِم هذه الصفحة

لم تجد ما كنت تبحث عنه؟

أو