Query results in the data grid that contains a CLOB datatype field will display “(HugeClob)”rather than the actual data.
How can a sample of the CLOB data cell be displayed?
Change the default behavior in the options menu:
1. Go to Tools | Options | Database | General in the main menu.
2. Check the "Read LOBs when initially fetching data" check box.
3. Click on Apply and OK.