Use the Table Data Editor to review and edit database tables that contain Character Large Objects (CLOBs). A CLOB is a collection of character data stored as a single entity in a Database Management System (DBMS).
The Clob Editor displays the character data contained in the selected Character Large Object (CLOB) stored in a database. You can edit the data in the CLOB by:
- Inserting character data
- Deleting character data
- Clearing the character data in the object
- Importing character data from a file
- Exporting the character data in the object
A CLOB data object can be represented in one of three ways:
- CLOB handle – Handle to the CLOB data in the database.
- Snippet of data – Text snippet you edit or insert in cell.
- Filename – For data objects over 64K, name of file that contains the data. You can edit or insert data in this file. CLOB data larger than 64K cannot be edited in the Clob Editor.