What's the difference between "commit" and "commit work"?

Question

I was asking in terms of the Oracle SQL*PLUS ...

Answer 1

Nothing - it's an optional statement

See here for more details

Quoting from this article:

To make the changes done in a transaction permanent issue the COMMIT statement.

The syntax of COMMIT Statement is

COMMIT [WORK] [COMMENT ‘your comment’];

WORK is optional.

COMMENT is also optional, specify this if you want to identify this transaction in data dictionary DBA_2PC_PENDING.

Answer 2

Five characters - ' WORK'.

:-)

However, the effect of both commands is identical.

Share and enjoy.

Answer 3

Nothing :-)

Oracle says

The WORK keyword is supported for compliance with standard SQL. The statements COMMIT and COMMIT WORK are equivalent.