New Features in SQL*Plus

Cours New Features in SQL*Plus, tutoriel & guide de travaux pratiques en pdf.

New Features in SQL*Plus 9.2

SQL*Plus Release 9.2.0 is a superset of SQL*Plus 9.0.1. This section describes new features introduced in this release of SQL*Plus.
XMLType Support There is additional support for XMLType in SQL*Plus. The DESCRIBE command now provides details about XMLType columns and usage in functions and procedures. The maximum size of a retrieved XMLType column is determined by SET LONG, and SET LONGCHUNKSIZE determines the size of the increments or chunks SQL*Plus uses to retrieve XMLType data.

SQLPLUS -L Argument There is a new command-line argument for the SQLPLUS command, SQLPLUS -L which specifies not to reprompt for username or password if the initial connection does not succeed. This can be useful in operating-system scripts that must either succeed or fail. It is also useful for situations where you do not want to be reprompted for connection details if the Server is not running. This option is not available with the SQL*Plus Windows graphical user interface.

_CONNECT_IDENTIFIER DEFINE Variable There is a new DEFINE variable _CONNECT_IDENTIFIER, which contains the SID as supplied by the user to make a connection where it is available. This allows the connection information to be accessed like any other DEFINE variable. For example, it could be used in TTITLE, in ’&’ substitution variables, or as your SQL*Plus command-line prompt by using the SET SQLPROMPT command. For example, to change your SQL*Plus prompt to display your username and SID, enter:
SET SQLPROMPT ’&_CONNECT_IDENTIFIER > ’
See Also:
■ « DESCRIBE » on page 13-53
■ « SET LONG {80|n} » on page 13-112
■ « SET LONGC[HUNKSIZE] {80|n} » on page 13-112
■ « Formatting Datatypes » on page 7-5.
See Also: « SQL*Plus Command Summary » on page 13-2.