How to empty/null a "SYS"."XMLTYPE"
Hello,
I'm not a guru on Oracle/SQL also not a beginner.
We want to do a export/import of a schema. Therefore some tables are very big but the data in this tables is not relevant on the dev environment, so we want to empty these columns.
Some columns are BLOB/CLOB. I can null and I see the lenth of these fields is also null, that's good I think. But there is one table with a column of "SYS"."XMLTYPE" type. How can empty/null this column with simple SQL (TOAD)
Any help would be appreciated. Thanks in advance,
Nico