Copy Table Data Query¶

The query block below is well used for copying one or more rows of a table into the same or another table with some modification if required.

begin
  for r in (select *
             from [TABLE]
             where
                 [CONDITION]
          )
  loop
      --change fields if needed
    SELECT NVL( MAX( idx ), 0 ) + 1 into r.idx from document_to;
    r.owner_id := #new_owner_id#;
    --insert new data in a new table or the same table
    insert into [TABLE] values r;
  end loop;
end;