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.