White Papers

More on Oracle Database 11g

Overview PL/SQL is Oracle's procedural extension to SQL, and it is a true 3GL programming language. It was first introduced way back in version 6 of the database, giving the ability to code "Anonymous blocks" in the client applications and submit them for processing on the database. In Oracle6, there were no stored procedures, no packages, and no triggers. The ability to store PL/SQL in the database came with version 7 in 1992. Today, PL/SQL is competent, mature, and full-featured, offering everything one expects to find in a 3GL programming language. In general, the author finds that PL/SQL is underused in Oracle applications and rarely exploited to its full potential.

Download White Paper

By downloading you agree to our Terms and Conditions. These include information regarding use of your personal data.

Publisher
Oracle
File Format
HTML
Date Published
Mar 29, 2008
Format
White Papers
Topics
Programming Languages, Database Management

Similiar White Papers

Building a Hybrid Data Warehouse Model

Building a Hybrid Data Warehouse Model

This paper discusses the hybrid design and provides a fully functional reference implementation. The system runs on Orac

Publisher: Oracle  |  Tags: data, database, warehouse

MySQL Stored Procedure Programming: Error Handling

MySQL Stored Procedure Programming: Error Handling

The perfect programmer, living in a perfect world, would always write programs that anticipate every possible circumstan

Publisher: O'Reilly Media  |  Tags: applications, business applications, server, shuttle, software

MSDN Webcast: Using LINQ With Relational Data (Level 100)

MSDN Webcast: Using LINQ With Relational Data (Level 100)

One of the most common forms of data used in applications today continues to be relational data that is stored in variou

Publisher: Microsoft  |  Tags: applications, data, database

MSDN Webcast: geekSpeak: T-SQL Tips and Tricks in SQL Server 2008 With Andrew Karcher (Level 200)

MSDN Webcast: geekSpeak: T-SQL Tips and Tricks in SQL Server 2008 With Andrew Karcher (Level 200)

This webcast is for Transact-SQL (T-SQL) lover. The presenter introduces to several new features of SQL Server 2008, inc

Publisher: Microsoft  |  Tags: data

Efficient Use of PL/SOL String Functions for Unicode Applications

Efficient Use of PL/SOL String Functions for Unicode Applications

This white paper focuses on performing implications of PL/SQL applications for Unicode database server using a UTF-8 dat

Publisher: Oracle Corporation  |  Tags: applications, database, server

Oracle White Papers

A Taxonomy of the Linux Network Stack

A Taxonomy of the Linux Network Stack

This paper tries to give readers not familiar with the Linux network stack a gentle introduction to the fundamental conc

Publisher: Oracle  |  Tags: data, ip, kernel, linux, network

GUIDEBOOK: ORACLE'S SIEBEL CRM ON DEMAND

GUIDEBOOK: ORACLE'S SIEBEL CRM ON DEMAND

Oracle's Siebel CRM On Demand has leveraged its history and experience in CRM to provide customers with deeper functiona

Publisher: Oracle  |  Tags: crm

Oracle Forms 10g - Forms Look and Feel

Oracle Forms 10g - Forms Look and Feel

Oracle Forms application have traditionally behaved as, and looked like, desktop applications. Even when Oracle Forms ap

Publisher: Oracle  |  Tags: applications, css

Oracle Blends Managed Services With OnDemand Pricing

Oracle Blends Managed Services With OnDemand Pricing

Growing businesses are increasingly realising that Managed Services offer a scalable, flexible route forward. This white

Publisher: Oracle

Ten Things to Know About Grid Computing on Windows

Ten Things to Know About Grid Computing on Windows

This Oracle whitepaper offers insights into Oracle Grid.A grid allows a business to add capacity, cheaply, whenever it i

Publisher: Oracle  |  Tags: application server, computing, database, server