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}