Oracle SQL*Plus: The Definitive Guide, 2nd Edition

Name

SET APPINFO

Synopsis

The APPINFO setting controls whether or not SQL*Plus automatically registers command files using the DBMS_APPLICATION_INFO package.

Syntax

SET APPI[NFO] {OFF | ON | app_text}

Paremeters

SET APPI[NFO]

Is the command, which may be abbreviated SET APPI.

OFF

Disables the automatic registration of command filenames. With this off, SQL*Plus will make an entry using the current value of app_text whenever you execute a command file.

ON

Enables the automatic registration of command files. This is the default setting.

app_text

Provides a text string that is used instead of the command filename. The default setting for this is "SQL*Plus".

Examples

The DBMS_APPLICATION_INFO package controls the contents of the module field in both the v$session and v$sqlarea views. Whenever you connect to a database, SQL*Plus registers itself as the active application by making a call to the DBMS_APPLICATION_INFO.SET_MODULE procedure. This sets the module name for your session to "SQL*Plus". This is reflected in the v$session view, as the following example demonstrates:

SELECT module FROM v$session WHERE username=USER;
MODULE
------------------------------------------------
SQL*Plus

SQL*Plus has the ability to update the module name whenever you execute a command file. The module name can be set to the command filename or to some arbitrary text that you specify. The default setting for APPINFO causes SQL*Plus to register the name of each command file you execute. So, if you execute a command file ...