# Displaying NCLOB columns

**URL:** <https://forums.toadworld.com/t/displaying-nclob-columns/39317>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [April 10, 2017, 9:10am UTC](https://forums.toadworld.com/t/displaying-nclob-columns/39317 "2017-04-10T09:10:33Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![schwartzl](https://avatars.discourse-cdn.com/v4/letter/s/5fc32e/32.png) [@schwartzl](https://forums.toadworld.com/u/schwartzl)\
**Post date:** [April 10, 2017, 9:10am UTC](https://forums.toadworld.com/t/displaying-nclob-columns/39317/1 "2017-04-10T09:10:33Z")

</div>

Hi, I need help to be able to display NCLOB type columns in my data-grids. I have TOAD ver 12.10.0.30 and ORACLE v 10.2.0.5.

I have checked both the “Preview LOB” and the “Deferred LOB” check-boxes, the respective columns do not show/display.

Any advice would be welcomed.

* * *

Table I am displaying:

int\> desc SPLT\_REP  
Name Null? Type

* * *

SID VARCHAR2(6)  
SPTY VARCHAR2(4)  
TY\_CNT NUMBER  
WSP\_TY NCLOB  
ISP\_TY NCLOB  
WH\_CNT NUMBER  
WH\_NET NUMBER  
COMNT VARCHAR2(4000)

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [April 10, 2017, 9:35am UTC](https://forums.toadworld.com/t/displaying-nclob-columns/39317/2 "2017-04-10T09:35:46Z")

</div>

If you are looking in the schema browse and the LOB columns just aren’t in the results, go to Options -\> Schema Browser -\> Data Tab -\> “Don’t select BLOB/CLOB columns”. Uncheck it.

Regarding Options -\> Data Grids -\> Data.

“Preview CLOB and LONG”, if checked, means you need to double-click on a CLOB cell in a grid to see the contents.

“Deferred LOB read” has to do with the timing on the loading of LOB data into the grid. I would leave this one unchecked.

---

<div class="post-metadata">

**Author:** ![schwartzl](https://avatars.discourse-cdn.com/v4/letter/s/5fc32e/32.png) [@schwartzl](https://forums.toadworld.com/u/schwartzl)\
**Post date:** [April 10, 2017, 9:56am UTC](https://forums.toadworld.com/t/displaying-nclob-columns/39317/3 "2017-04-10T09:56:55Z")

</div>

THX that worked perfectly - didn’t think of checking “Schema Browser” settings.

---

<div class="post-metadata">

**Author:** ![pawanrakesh](https://avatars.discourse-cdn.com/v4/letter/p/a698b9/32.png) [@pawanrakesh](https://forums.toadworld.com/u/pawanrakesh)\
**Post date:** [August 21, 2021, 7:57pm UTC](https://forums.toadworld.com/t/displaying-nclob-columns/39317/4 "2021-08-21T19:57:48Z")

</div>

Hi @JohnDorlon I have “Preview CLOB and LONG” unchecked, but still I have to double-click on a CLOB cell in a column to see the contents.

Is there any other settings that I am supposed to check ? SO that I can view the CLOB contents inside the grid rather than double-clicking to view it.

using toad 12.8

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [August 21, 2021, 9:55pm UTC](https://forums.toadworld.com/t/displaying-nclob-columns/39317/5 "2021-08-21T21:55:45Z")

</div>

You should check (not uncheck) that option if you want to see the data in the grid without having to double-click it.