|SQL*Plus® User's Guide and Reference
|PDF · Mobi · ePub|
This section describes new features of the SQL*Plus Release 10.2 and provides pointers to additional information.
SQL*Plus Release 10.2 is a superset of SQL*Plus 10.1. This section describes new features introduced in SQL*Plus Release 10.2.
SQL*Plus Supports Lightweight Instant Client
The SQL*Plus Instant Client now supports Lightweight Instant client and documentation is included in the SQL*Plus User's Guide and Reference.
AUTOTRACE PLAN Output
Autotrace Plan output now includes additional information and use the DBMS_XPLAN package format.
See Also:Execution Plan
SET SERVEROUTPUT Changes
SET SERVEROUTPUT supports an UNLIMITED size which is the new default.
DBMS_OUTPUT line length limit is increased to 32767 bytes from 255.
You can SET ARRAYSIZE to tune the performance of SET SERVEROUTPUT.
XQUERY is a new SQL*Plus command that enables you to run XQueries against your database in SQL*Plus or iSQL*Plus. There are four new SETXQUERY options associated with this command, SET XQUERY BASEURI, ORDERING, NODE, and CONTEXT.