Monday, May 7, 2018

The COMMIT Statement

https://plsqlquery.blogspot.com/2018/05/the-commit-statement.html

The COMMIT Statement is used to save data permanently into database. All DDL and DCL statements execute automatic commit. Commit is also executed automatically in some other cases. After DML statements you have to use COMMIT statement for permanently saving.

SQL> commit;

commit complete
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

XLA to GL Link

  https://plsqlquery.blogspot.com/2025/12/xla-to-gl-link.html SELECT             acr.cash_receipt_id,             acr.receipt_number,       ...

  • Using Outer Joins in PLSQL Query
    https://plsqlquery.blogspot.com/2018/05/using-outer-joins-in-plsql-query.html We use Outer Join when mismatched Values to be displayed    ...
  • Using TRIM in PLSQL Query
    https://plsqlquery.blogspot.com/2018/05/using-trim-in-plsql-query.html The Oracle/PLSQL TRIM function removes all specified characters eit...
  • Using Trunc Function with Numbers in PLSQL
    https://randomsrsolutions.blogspot.com/2018/05/using-trunc-function-with-numbers-in.html The TRUNC function Truncates the Column, Expressi...