oracle循环

declare  
begin
		
  for i in 1..6 loop
	for j in 1..24 loop
  dbms_output.put_line(to_char(trunc(sysdate-44+i),'yyyy-mm-dd')||' '||lpad(j-1,2,0)); end loop; end loop; end;

  

原文地址:https://www.cnblogs.com/YuanFan123/p/7251575.html