Edit the Oracle Clob data type value

In pl/SQL tools, you need to change the value of a field in a line:

Method 1.

Repeat the table to edit the data.

In this way, you can see the data you want to change at a glance when the data volume is small.

However, when the data volume is large, the update statement is required.

If you update a clob-type data, for example, the following allcode field is clob-type.

Update... set allcode = '.......'

This is incorrect because clob is an object-type data and cannot be caused by single quotation marks. In addition, clob data usually contains a large amount of data. Therefore, you need to write all the new values in the update directly, which is troublesome and may not be able to write all the new values. Therefore, the correct method to change the clob data value is as follows:

1. select for update. After this row of data is selected, it will be locked. The lock appears above the data displayed in the pl/SQL editor.

2. open the lock and move the mouse to the lock. The word "edit data" should be displayed. After the lock is clicked, the lock becomes the lock on.

3. Find the field clob you want to change, click the ellipsis next to the field, change it in it, close the window after the change, and prompt you to save. After saving, the submission is submitted. This completes the change.