plSQL introduction - Introducing PL/SQL Learning objective...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Introducing PL/SQL Learning objective After completing this topic, you should be able to recognize the correct structure of a PL/SQL program block. 1. PL/SQL features and benefits Structured Query Language (SQL) is the main programming language used to access and modify data in relational databases. The Procedural Language extension to SQL, called PL/SQL, expands the programming capabilities of SQL. Important features of PL/SQL include block structure modern software features third-generation language constructs block structure PL/SQL defines a block structure for writing code. This makes it easier to maintain and debug the code by standardizing the flow and execution of the program unit. modern software features PL/SQL includes modern software engineering features, such as data encapsulation, exception handling, information hiding, and object orientation. third-generation language constructs PL/SQL provides the same procedural constructs as any third-generation language (3GL), including variables, constants, and types control structures, such as conditional statements and loops reusable program units that are written once and executed many times PL/SQL uses the same data types as SQL, but it also includes some extra extensions. It also uses the same expression syntax. There are a number of benefits from using PL/SQL in a database: integration of procedural constructs with SQL improved performance modularized program development integration with tools portability integration of procedural constructs with SQL
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
PL/SQL enables you to integrate procedural constructs, such as control and conditional statements, into SQL commands. For example, you can use PL/SQL to make changes to a database record depending on the values in another record. improved performance PL/SQL improves the performance of your database by reducing the number of SQL commands you send to the database. modularized program development PL/SQL programs use blocks as their basic units. This gives you a number of advantages in database programming, including the logical grouping of related statements within blocks the nesting of blocks inside larger blocks to build powerful programs the ability to break up an application into smaller modules integration with tools The PL/SQL engine is combined with tools, such as Oracle Forms and Oracle Reports. These tools allocate the job of processing the procedural statements to the locally available PL/SQL engine and pass only the SQL statements to the database. portability PL/SQL commands can be run on any Oracle server regardless of the operating system (OS) and the network platform. They do not need to be changed to suit different network environments, which enables you to create portable program packages and libraries. Here's an example of how PL/SQL improves the database performance.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 12/22/2009 for the course DBST DBST 651 taught by Professor Yelena - ta during the Spring '09 term at MD University College.

Page1 / 56

plSQL introduction - Introducing PL/SQL Learning objective...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online