How to Update Millions of Records in a Single Column Without Using PL/SQL Loops

 Hi All,

I'm trying to update a column of a table containing 50 million records (11gR2). I don't want to use PL/SQL Loops or Bulk Collect but I'm also not able to use the full CTAS / rename table approach either. What I have at the moment is something along the lines of the following:

Main Table:

CREATE TABLE transactions

(id VARCHAR2(32),

 xmlcontent XMLTYPE,

 xmlsize NUMBER(10)

);

I need to be able to calculate the size of the XMLCONTENT column and store it in the XMLSIZE column, to that end...

-- Enable Parallel DML for the session

ALTER SESSION ENABLE PARALLEL DML;