optim_rqe_temp_tbl.sql

create global temporary table temp_agregat_metier(
    d1 date,
    c1 varchar2(100),
    c2 varchar2(100),
    c3 varchar2(20),
    c4 number,
    c5 varchar2(30),
    c6 number,
    c7 number,
    c8 number
) on commit preserve rows;

create global temporary table temp_requete_metier(
    d1 date,
    ca varchar2(60),
    cb number,
    cc varchar2(10),
    c1 varchar2(100),
    c2 varchar2(100),
    c3 varchar2(20),
    c4 number,
    c5 varchar2(30),
    c6 number,
    c7 number,
    c8 number
) on commit preserve rows;