NoLogging & Parallel Queries Example

create or replace procedure erp_crs_base_populate as
begin
insert /*+ append parallel (n,4) */ into apps.erp_crs_6mth
(select /*+ parallel (x,4) */ * from apps.oe_order_lines_all where CREATION_DATE > TO_DATE('15-OCT-2003','DD-MON-RRRR'));
commit;
end;