• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 778
  • Last Modified:

Size of a 'clob' field in oracle 10g?

can i find the size of a 'clob' field for one specific row in a table? we have oracle 10g.
0
Rao_S
Asked:
Rao_S
1 Solution
 
sdstuberCommented:
select dbms_lob.getlength(yourcolumn) from yourtable where ....
0
 
Rao_SAuthor Commented:
thank you..
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now