-
How to get the size of an XMLTYPE column in a row
I've got a table, my_table with a column of XMLTYPE called xmldoc. This table has thousands of records. I would like to get the size of the xmldoc column for each row. I suppose I could open the value in the TOAD editor, copy the XML, past it in notepad and check the size...is there an easier way?
This didn't seem to do it:
select avg(vsize(XMLDOC)) from my_table
I appreciate any help. Thanks.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|