CLOB Stands for "Character Large Object."
A CLOB is a data type used by various database management systems, including Oracle and DB2.It stores large amounts of character data, up to 4 GB in size.
PeopleSoft store Expressions and SQL coding in this type of field which returns with <CLOB> in the field when querying the data using PL/SQL
You can select the Large Data Editor Window for a single field by selecting the 3 ellipses ... in the upper right corner of the cell (in yellow below)
You can also export(copy)** the CLOB Field Data to an Excel File using the "Copy To Excel" Option to create an Excel Sheet.
**Note that the data will not export using the "Export to Excel" Option.
