create or replace pro (pdate in date) is
vdate date;
i number;
begin
vdate:=next_day(pdate,'sunday');
i:=1;
while(i<7) loop
select column_name into 变量 from table where date_column=vdate-i;;
dbms-output.put_line(变量);
end loop;
end pro;
vdate date;
i number;
begin
vdate:=next_day(pdate,'sunday');
i:=1;
while(i<7) loop
select column_name into 变量 from table where date_column=vdate-i;;
dbms-output.put_line(变量);
end loop;
end pro;
借光啊
谁懂彻底卸载developer啊,
[email protected]
qq 95198440
select next_day(trunc(sysdate)-1,1)-6, next_day(trunc(sysdate)-1,1) from dual;
(把sysdate改成用户输入的日期)问题二:
select 车型,公司,sum(decode(对象月,'1月',产量)), sum(sum(decode(对象月,'2月',产量)),sum(decode(对象月,'3月',产量)),...
from ...
where
...
group by 车型,公司
;