declare l_tmp char(1); l_start number := dbms_utility.get_time; begin
select * into l_tmp from t1;
select * into l_tmp from t2;
select * into l_tmp from t3;
select * into l_tmp from t4;
select * into l_tmp from t5;
select * into l_tmp from t6;
select * into l_tmp from t7;
select * into l_tmp from t8;
select * into l_tmp from t9;
select * into l_tmp from t10;
select * into l_tmp from t11;
select * into l_tmp from t12;
select * into l_tmp from t13;
select * into l_tmp from t14;
select * into l_tmp from t15;
select * into l_tmp from t16;
select * into l_tmp from t17;
select * into l_tmp from t18;
select * into l_tmp from t19;
select * into l_tmp from t20;
select * into l_tmp from t21;
select * into l_tmp from t22;
select * into l_tmp from t23;
select * into l_tmp from t24;
select * into l_tmp from t25;
select * into l_tmp from t26;
select * into l_tmp from t27;
select * into l_tmp from t28;
select * into l_tmp from t29;
select * into l_tmp from t30;
select * into l_tmp from t31;
select * into l_tmp from t32;
select * into l_tmp from t33;
select * into l_tmp from t34;
select * into l_tmp from t35;
select * into l_tmp from t36;
select * into l_tmp from t37;
select * into l_tmp from t38;
select * into l_tmp from t39;
select * into l_tmp from t40;
select * into l_tmp from t41;
select * into l_tmp from t42;
select * into l_tmp from t43;
select * into l_tmp from t44;
select * into l_tmp from t45;
select * into l_tmp from t46;
select * into l_tmp from t47;
select * into l_tmp from t48;
select * into l_tmp from t49;
select * into l_tmp from t50;
select * into l_tmp from t51;
select * into l_tmp from t52;
select * into l_tmp from t53;
select * into l_tmp from t54;
select * into l_tmp from t55;
select * into l_tmp from t56;
select * into l_tmp from t57;
select * into l_tmp from t58;
select * into l_tmp from t59;
select * into l_tmp from t60;
select * into l_tmp from t61;
select * into l_tmp from t62;
select * into l_tmp from t63;
select * into l_tmp from t64;
select * into l_tmp from t65;
select * into l_tmp from t66;
select * into l_tmp from t67;
select * into l_tmp from t68;
select * into l_tmp from t69;
select * into l_tmp from t70;
select * into l_tmp from t71;
select * into l_tmp from t72;
select * into l_tmp from t73;
select * into l_tmp from t74;
select * into l_tmp from t75;
select * into l_tmp from t76;
select * into l_tmp from t77;
select * into l_tmp from t78;
select * into l_tmp from t79;
select * into l_tmp from t80;
select * into l_tmp from t81;
select * into l_tmp from t82;
select * into l_tmp from t83;
select * into l_tmp from t84;
select * into l_tmp from t85;
select * into l_tmp from t86;
select * into l_tmp from t87;
select * into l_tmp from t88;
select * into l_tmp from t89;
select * into l_tmp from t90;
select * into l_tmp from t91;
select * into l_tmp from t92;
select * into l_tmp from t93;
select * into l_tmp from t94;
select * into l_tmp from t95;
select * into l_tmp from t96;
select * into l_tmp from t97;
select * into l_tmp from t98;
select * into l_tmp from t99;
select * into l_tmp from t100;
dbms_output.put_line( round( (dbms_utility.get_time-l_start)/100, 2 )||' seconds' );
end;
/
