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...