With the knowledge of more and more, but also more and more found their own shortcomings, simply record the learning of the knowledge bar.
Although Oracle is used in the project, it is not really a sufficient application for Oracle, for example, if I look at the data in a table, for example:
This time the two data is my input test data, and now I want to delete the operation, maybe I can quickly think of the corresponding SQL statement:
Delete from Arc_tobaccotechnician where name like '% is% '
First of all, it's right, and it's very fast, but what if the common denominator of the test data is not so easy to find, or is it difficult to write other SQL?
Today I know a small method, the record, the feeling is quite useful:
For the convenience of viewing, I directly join the "for update", can actually write directly select * from + table name +for update
Then do the following:
See what's different from the picture above, yes, "lock" is turned on, and "plus" and "minus" all become operational, and then we can click on "+" and "-" to a row of data directly "add" or "delete", then delete it, you can directly modify the data, And then
Found this small place, feel a lot of bullish, haha, rookie is very easy to find the sense of accomplishment ah, oh, yes, do not forget the final submission OH
Well, this little place is recorded here, very open sen ...
Accumulate Kuibu, Poly stream------Oracle Easy to modify entire rows of data