createprocedure.sql

来自「本文件为Oracle 9i中文版基础培训教程」· SQL 代码 · 共 10 行

set  serveroutput  on
create or replace procedure tempuser.tempprocedure as
  tempdate   tempuser.testtable.currentdate%type;
begin
  select  currentdate 
  into    tempdate
  from    testtable
  where   recordnumber=88;
  dbms_output.put_line(to_char(tempdate));
end;