CHAPTER 8 Application Development

Several new and improved features related to application development are present in Oracle Database 11g. These include SQL*Plus features, new online maintenance types of operations, new SQL features, and finally new PL/SQL-related features. So let's dive into these new features in some more detail.


Oracle Database 11g has added new features to SQL*Plus including new set commands and Fast Application Notification (FAN) events. In this section we will discuss the new set commands first. We will then look at FAN events from RAC.

New set Commands

In this first section we will discuss the SQL*Plus new set commands. First we will discuss the new set esschar. We will then cover the set errorlogging, command. ...

Get Oracle Database 11g New Features now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.