CODEWITHSUNDEEP
sqloracle-databasetoadsqldatatypes
yami jain
yami jain

Reputation: 21

Details on HUGECLOB in oracle

I have seen many tables in toad where the column data is coming as 'HUGECLOB'. Can someone explain me how to see such type of columns and before that what are the data type of those columns and how do we store the xml or sql text file inside that

Upvotes: 2

Views: 15797

Answers (1)

Wano_Anth
Wano_Anth

Reputation: 56

In TOAD the value of a field returning (HUGHCLOB) can be viewed by double clicking the (HUGECLOB) value in the row. This will open a grid popup editor with the full value of the field.

If you want to view the data via sql try:

SELECT DBMS_LOB.SUBSTR(FIELD_NAME, LENGTH YOU WANT(EX: 4000), STARTING CHARACTER(Ex: 1)) FROM TABLE;

This will allow you to view the beginning characters up to the length you specify.

Upvotes: 3

Related Questions