生成循环建索引sql

set serveroutput on;
declare
 vsql varchar(4000);
 
begin
 for i in 1..28
 loop
select 'CREATE INDEX HYPTRAW.IDX_TRANS_VEH_LOCATE_201702'||lpad(i,2,0)||' ON HYPTRAW.TRANS_VEHICLE_LOCATE_201702'||lpad(i,2,0)||'(CODE, GPS_TIME) COMPRESS 1;' into vsql from dual;
dbms_output.put_line(vsql);
end loop;
end;