先 SET SERVEROUTPUT ON 然后 declare row_count number; END_DATE DATE; begin END_DATE := SYSDATE; row_count := 0; select count(*) into row_count from sapdt_wakh where logdate < end_date; dbms_output.put_line('this is the count:'||to_char(row_count)); end;
然后
declare
row_count number;
END_DATE DATE;
begin
END_DATE := SYSDATE;
row_count := 0;
select count(*)
into row_count
from sapdt_wakh where logdate < end_date;
dbms_output.put_line('this is the count:'||to_char(row_count));
end;
END_DATE := SYSDATE;
这样子赋值的话,END_DATE的值就是 NLS_DATE_FORMAT里面设置的格式