Step by step, gathering small streams ------ oracle easily modifies the entire row of data, ------ oracle

Source: Internet
Author: User

Step by step, gathering small streams ------ oracle easily modifies the entire row of data, ------ oracle

As you learn more and more about your knowledge and discover your own shortcomings, record the knowledge you learned this time.

Although oracle is used in the project, it is not very good for oracle applications. For example, if I check the data in a table, for example:


At this time, the two pieces of data are the test data I have entered. Now I want to delete the data, and I may soon be able to think of the corresponding SQL statement:

Delete from arc_tobaccotechnician where name like '%'

First of all, this is right, and it is very quick, but if the test data is not so easy to find, or other SQL statements will be very troublesome to write?

Today I learned a small method and recorded it. It seems quite useful:


For ease of viewing, I directly add "for update", in fact, you can directly write select * from + Table name + for update

Perform the following operations:


Is there anything different from the above picture? Yes, the lock is opened, and the plus sign and minus sign become operable, then we can click "+" and "-" to add or delete a row of data. How can we delete the row, you can modify the data directly, and then


I felt a lot cool when I found this small place. Haha, cainiao is very easy to find a sense of accomplishment. Oh, by the way, never forget the final submission.


Okay, this small place is recorded here. It's very helpful...


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.