What's New in SQL*Plus?

This section describes new features of the SQL*Plus Release 10.2 and provides pointers to additional information.

New Features in SQL*Plus Release 10.2

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.

  See Also:

  Starting SQL*Plus Instant Client

  Appendix E, "SQL*Plus Instant Client"

• 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.

  See Also:

  SET SERVEROUT[PUT] {ON | OFF} [SIZE {n | UNL[IMITED]}] [FOR[MAT] {WRA[PPED] | WOR[D_WRAPPED] | TRU[NCATED]}]

  Oracle Database PL/SQL Packages and Types Reference

• XQUERY Command

  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.

  See Also:

  XQUERY

  SET XQUERY BASEURI {text}

  SET XQUERY ORDERING {UNORDERED | ORDERED | DEFAULT}

  SET XQUERY NODE {BYVALUE | BYREFERENCE | DEFAULT}

  SET XQUERY CONTEXT {text}