问一下,如何付值给前面的变量呢????
这样写好像不行喔````求教!tBeginYearMonth:= select to_char(min(yearmonths),'yyyymm')myear from (select add_months(trunc(to_date(200905,'yyyymm'),'Q'),rownum-1)yearmonths from dual connect by rownum<=3)
这样写好像不行喔````求教!tBeginYearMonth:= select to_char(min(yearmonths),'yyyymm')myear from (select add_months(trunc(to_date(200905,'yyyymm'),'Q'),rownum-1)yearmonths from dual connect by rownum<=3)
tBeginYearMonth date;
begin
tBeginYearMonth := sysdate;
end;要从select语句中进行赋值,就需要用 into了