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 ...
Get Oracle SQL*Plus: The Definitive Guide, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.