Native cloud deployment on Azure is currently not available for Exasol 8, but you can install Exasol as a Linux application on Azure VM instances. For more information, see Installation.

Native cloud deployment on GCP is currently not available for Exasol 8, but you can install Exasol as a Linux application on GCP VM instances.

ROLLBACK

Purpose

Use this statement to withdraw changes of the current transaction.

Prerequisite

None

Syntax

rollback::=

Rollback statement

Usage Notes

The keyword WORK is optional and is only supported to conform to the SQL standard.
For more information on transactions, see Transaction Management.

Example

CREATE TABLE t (i DECIMAL);
COMMIT;
INSERT INTO t values (1);
SELECT COUNT(*) FROM t;

ROLLBACK;
SELECT COUNT(*) FROM t;