create or replace procedure print_current_time as
@curtime varchar(20);
begin
select To_CHAR(sysdate,'yyyy/mm/dd hh24:mi:ss')
into @curtime
from dual;
DBMS_OUTPUT.put_line('当前时间是:'||chr(9)||@curtime);
end print_current_time;
@curtime varchar(20);
begin
select To_CHAR(sysdate,'yyyy/mm/dd hh24:mi:ss')
into @curtime
from dual;
DBMS_OUTPUT.put_line('当前时间是:'||chr(9)||@curtime);
end print_current_time;
curtime varchar(20);
begin
select To_CHAR(sysdate,'yyyy/mm/dd hh24:mi:ss')
into curtime
from dual;
DBMS_OUTPUT.put_line('当前时间是:'||chr(9)||@curtime);
end print_current_time;
去掉*