Oracle9i SQL Reference Release 1 (9.0.1) Part Number A90125-01 |
|
This section describes new features of Oracle9i Release 1 (9.0.1) and provides pointers to additional information. Oracle8i new features information is also retained to help those users migrating from Oracle7 to Oracle9i Release 1 (9.0.1).
The following sections describe the new features in the Oracle9i SQL Reference:
The following built-in datatypes are new or modified in this release:
CHAR
or BYTE
parameter to indicate character or byte semantics, respectively.
CHAR
or BYTE
parameter to indicate character or byte semantics, respectively.
The following expression forms are new or enhanced in this release:
REF
CURSOR
arguments to functions)
The following condition is new in this release:
The following built-in functions are new to this release:
ASCIISTR
BIN_TO_NUM
COALESCE
COMPOSE
CURRENT_DATE
CURRENT_TIMESTAMP
DBTIMEZONE
DECOMPOSE
EXISTSNODE
EXTRACT (datetime)
EXTRACT (XML)
FIRST
FROM_TZ
GROUP_ID
GROUPING_ID
LAST
LOCALTIMESTAMP
NULLIF
PERCENTILE_CONT
PERCENTILE_DISC
RAWTONHEX
ROWIDTONCHAR
SESSIONTIMEZONE
SYS_CONNECT_BY_PATH
SYS_DBURIGEN
SYS_EXTRACT_UTC
SYS_XMLAGG
SYS_XMLGEN
SYSTIMESTAMP
TO_CHAR (character)
TO_CLOB
TO_DSINTERVAL
TO_NCHAR (character)
TO_NCHAR (datetime)
TO_NCHAR (number)
TO_NCLOB
TO_TIMESTAMP
TO_TIMESTAMP_TZ
TO_YMINTERVAL
TREAT
TZ_OFFSET
UNISTR
WIDTH_BUCKET
The following functions are enhanced for this release:
The following privileges are new to this release:
EXEMPT ACCESS POLICY
system privilege
RESUMABLE
system privilege
SELECT ANY DICTIONARY
system privilege
UNDER ANY TYPE
system privilege
UNDER ANY VIEW
system privilege
UNDER
object privilege
The following top-level SQL statements are new to this release:
The following SQL statements have new syntax:
ALTER DATABASE
has new syntax that lets you end a "hot backup" procedure while the database is mounted. It also has new syntax related to standby databases.
ALTER INDEX
lets you gather statistics on index usage.
ALTER OUTLINE
allows modification of both public and private outlines.
ALTER ROLE
lets you identify a role using an application-specified package
ALTER SESSION
lets you specify whether statements issued during the session can be suspended under some conditions.
ALTER SYSTEM
has extended SET
clause; lets you put the database in quiesed state.
ALTER TABLE
allows partitioning by a list of specified values.
ALTER TYPE
lets you modify the attribute or method definition of an object type.
ALTER VIEW
lets you add constraints to views.
ANALYZE
now has ONLINE
and OFFLINE
clauses as part of the VALIDATE
STRUCTURE
syntax. In addition, you can now choose whether to collect standard statistics, user-defined statistics, or both.
CREATE CONTEXT
has added syntax to let you initialize the context from the LDAP directory or from an OCI interface and to make the context accessible throughout an instance.
CREATE CONTROLFILE
allows creation of Oracle-managed files.
CREATE DATABASE
lets you create default temporary tablespaces when you create the database; lets you create undo tablespaces.
CREATE FUNCTION
lets you create pipelined and parallel table functions and user-defined aggregate functions.
CREATE OUTLINE
allows creation of both public and private outlines.
CREATE ROLE
lets you identify a role using an application-specified package.
CREATE TABLE
allows creation of external tables (tables whose data is outside the database); allows creation of Oracle-managed files; allows partitioning by a list of specified values.
CREATE TABLESPACE
allows for segment space management by bitmaps as well as by free lists; allows creation of Oracle-managed files; lets you create undo tablespaces.
CREATE TEMPORARY TABLESPACE
allows creation of Oracle-managed files.
CREATE TYPE
lets you create subtypes.
CREATE VIEW
lets you create subviews of object views; lets you define constraints on views.
DROP TABLESPACE
has added syntax that lets you drop operating system files when you drop the contents from a dropped tablespace.
INSERT
has added syntax that lets you insert default column values.
SELECT
lets you specify multiple groupings in the GROUP BY clause, for selective analysis across multiple dimensions; lets you assign names to subquery blocks; has new ANSI-compliant join syntax.
SET TRANSACTION
lets you specify a name for a transaction.
UPDATE
has added syntax that lets you update to default column values.
The following SQL functions are new to this version:
BITAND
CORR
COVAR_POP
COVAR_SAMP
CUME_DIST
DENSE_RANK
FIRST_VALUE
LAG
LAST_VALUE
LEAD
NTILE
NUMTOYMINTERVAL
NUMTODSINTERVAL
NVL2
PERCENT_RANK
RANK
RATIO_TO_REPORT
STDDEV_POP
STDDEV_SAMP
VAR_POP
VAR_SAMP
The following top-level SQL statements are new to Release 8.1.5:
ALTER DIMENSION
ALTER JAVA
ALTER OUTLINE
ASSOCIATE STATISTICS
CALL
CREATE CONTEXT
CREATE DIMENSION
CREATE INDEXTYPE
CREATE JAVA
CREATE OPERATOR
CREATE OUTLINE
CREATE TEMPORARY TABLESPACE
DISASSOCIATE STATISTICS
DROP CONTEXT
DROP DIMENSION
DROP INDEXTYPE
DROP JAVA
DROP OPERATOR
DROP OUTLINE
In addition, the following features have been enhanced:
CREATE TABLE
.
|
![]() Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|