1 / 10

MATERI

PL/SQL. Oracle Developer. MATERI. Procedures. Functions. Packages. Database Triggers. PL/SQL. Introduction. PL/SQL is the procedural extension to SQL with design features of programming langguages DML and query statements of SQL are included within procedural units of code. About PL/SQL.

josephktaylor
Download Presentation

MATERI

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. PL/SQL Oracle Developer MATERI Procedures Functions Packages Database Triggers

  2. PL/SQL Introduction

  3. PL/SQL is the procedural extension to SQL with design features of programming langguages DML and query statements of SQL are included within procedural units of code About PL/SQL

  4. PL/SQL engine PL/SQL SQL Oracle Server PL/SQL Environment PL/SQL Block PL/SQL Block Procedural Statement Executor SQL statement executor

  5. Integration Benefits of PL/SQL Application Oracle Server Shared library

  6. Improved Performance Benefits of PL/SQL SQL Other DBMSs Application SQL SQL SQL SQL IF...THEN SQL ELSE SQL END IF; SQL Oracle with PL/SQL Application

  7. Modularize program development Benefits of PL/SQL DECLARE BEGIN EXCEPTION END;

  8. It is portable. You can declare identifiers. You can program with procedural language control structures. It can handle errors. Benefits of PL/SQL

  9. Easy maintenance Improved data security and integrity Improved Performance Improved code clarity Benefits of Subprograms

  10. Invoking Subprograms LOG_EXECUTION procedure PROCEDURE leave_emp Developer Portal Discoverer Another Proc. or Functions iSQL*Plus

More Related