SCOTT 01-JAN-04 >DEFINE database=betatwo SCOTT 01-JAN-04 >SET SQLPROMPT 'database _user _date >' betatwo SCOTT 01-JAN-04 >
You can now start SQL*Plus, setting the SQL*Plus compatibility variable (defined by a -c at the SQL*Plus command line) when you execute the SQL*Plus client. This allows you to set this variable before the global or local parameter files are executed. This is done when the SQL*Plus client is started via the use of the -c command-line parameter, followed by the Oracle Database version you wish the SQL*Plus session to be compatible with. Here is an example:
C:\ sqlplus -c 9.2 ''sys as sysdba"
In Oracle Database 10g, whitespace can be included in file- and pathnames. Commands such as spool, @, @@, and run all can benefit from this new functionality. Here is an example:
SPOOL "output report.txt"
There are a number of other new features in SQL*Plus. The SQL*Plus copy command has new error messages associated with it. The new show recyclebin command will display items that are currently in the recycle bin and available for purging. Also, the pagesize default in Oracle Database 10g has been changed from 24 to 14.
Oracle Database 10g provides new SQL language functionality. This section highlights some of these new features, including the following:
Data type enhancements
Moving data between BFILEs and LOB data types
The ability to create before insert and update triggers on LOB columns
New functionality for the returning clause
The new SQL model clause