New DEFAULT VALUES clause, INSERT statement   The new DEFAULT VALUES clause of the INSERT statement allows you to insert the default values for all columns. See INSERT statement.

CREATE ENCRYPTED DATABASE statement   This statement creates an encrypted copy of an existing database, including all transaction logs, mirror logs, and dbspaces. You can also use this statement to create a copy of a database with table encryption enabled. See CREATE ENCRYPTED DATABASE statement.

If you want to encrypt a database that requires recovery, for example to send to technical support, you must still use the CREATE ENCRYPTED FILE statement. See CREATE ENCRYPTED FILE statement.

CREATE DECRYPTED DATABASE statement   This statement creates a decrypted copy of an existing database, including all transaction logs, mirror logs, and dbspaces. See CREATE DECRYPTED DATABASE statement.

If you want to decrypt a database that requires recovery, for example to send to technical support, you must still use the CREATE DECRYPTED FILE statement. See CREATE DECRYPTED FILE statement.

ALTER DATABASE statement enhancement   Attempting to execute an ALTER DATABASE UPGRADE statement on a database server that is currently being mirrored now results in an error. See ALTER DATABASE statement.

MESSAGE statement enhancement   The IMMEDIATE clause causes the message to be received by the client's message callback routine within a short period of time, regardless of whether the connection is idle or making requests. See MESSAGE statement.

Create or replace a function, procedure, trigger, or view of the same name   The new OR REPLACE clause allows you to create or replace a function, procedure, trigger, or view of the same name. See:

• CREATE FUNCTION statement [Web service]
• CREATE PROCEDURE statement [Web service]
• CREATE TRIGGER statement
• CREATE VIEW statement

Suppressing errors when a statement attempts to remove a database object that does not exist   The new IF EXISTS clause allows you to specify that you do not want an error returned when the DROP statement attempts to remove a database object that does not exist. See:

• DROP EVENT statement
• DROP FUNCTION statement
• DROP MATERIALIZED VIEW statement
• DROP PROCEDURE statement
• DROP TABLE statement
• DROP TRIGGER statement
• DROP VIEW statement

New INTO LOCAL TEMPORARY TABLE clause, SELECT statement   The new INTO LOCAL TEMPORARY TABLE clause of the SELECT statement allows you to create and populate a local temporary table with the result set of a SELECT statement. Previously, you could only do this by using an INTO clause if the temporary table name started with #. See SELECT statement.

New IF NOT EXISTS clause, CREATE TABLE statement   The new IF NOT EXISTS clause of the CREATE TABLE statement allows you to create permanent, global temporary, and local temporary tables if the table does not already exist. See CREATE TABLE statement.

Specify an owner when creating temporary procedures or functions   The CREATE FUNCTION and CREATE PROCEDURE statements now allow you to optionally specify the owner for a temporary procedure or function. See:

• CREATE FUNCTION statement [Web service]
• CREATE PROCEDURE statement [Web service]