Oracle8i Migration
Release 8.1.5

A67774-01

Library

Product

Contents

Index

Prev Next

E
New Internal Datatypes and SQL Functions

This appendix lists the new internal datatypes and SQL functions added in version 8. This appendix covers the following topics:

Internal Datatypes Added in the New Release

The internal datatypes listed in this section are new in version 8. Each may be used as a function name in a SELECT list, but only if it is qualified with a schema (schema.function) as in the following example:

select scott.true() ...

In version 8, if a schema qualification is missing, these words generate an error, while, in version 7, their unqualified use did not generate an error.

Internal Datatypes Added in Release 8.0

The following internal datatypes were added in release 8.0:

Internal Datatype Added in Release 8.1

The following internal datatype was added in release 8.1:

SQL Functions Added in the New Release

The SQL functions listed in this section are new in version 8.

SQL Functions Added in Release 8.0

The following SQL functions were added in release 8.0:

Single-Row Functions

The following single-row functions were added in release 8.0:

Object Reference Functions

The following object reference functions were added in release 8.0:

SQL Functions Added in Release 8.1

The following functions were added in release 8.1:

Character Functions

The following character function was added in release 8.1:

Conversion Functions

The following conversion function was added in release 8.1:

Aggregate Functions

The following aggregate function was added in release 8.1:

Single-Row Functions

The following single-row functions were added in release 8.1:




Prev

Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index