Settings for automatic transaction submission by PL/SQL Developer

Source: Internet
Author: User

Settings for automatic transaction submission by PL/SQL Developer

Previously, the update table was used on a test machine. There was no commit or PL/SQL Developer.

The next day, I checked the table on my computer and found that the record was not updated.

I want to use the SQL statement to re-update it. It has not been executed for more than 10 minutes.

To manually update the file again, the following message is displayed:

At this point, we found that the table has been locked because update was used on the test machine but not submitted (commit )!!

DML operations such as insert, delete, update, select... for update will trigger the table-Level Lock and row-Level Lock,

After the DML operation, the table is locked before the commit operation, and other transactions cannot operate on the table!

Therefore, after the DML operation, remember to add the statement: commit; or manually Click Commit.

In addition, PL/SQL Developer provides the settings for automatic submission:

A. Automatic commit after the transaction is executed: Tools-> Preferences-> Window Types-> SQL Window: Select "AutoCommit SQL" to enable automatic commit.

B. Log out and submit automatically: Tools> Preferences> Oracle> Connection> Log off with open transaction: Select "Commit ".

-------------------------------------- Split line --------------------------------------

Rlwrap

SQLPLUS spool to dynamic Log File Name

Oracle SQLPLUS prompt settings

Accelerate SQL return by setting SQLPLUS ARRAYSIZE (row prefetch)

PL/SQL Developer Practical Skills

-------------------------------------- Split line --------------------------------------

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.