rowtypedefine.sql

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

Declare
  mytable testtable%rowtype;
begin
  select * into mytable 
  from  tempuser.testtable
  where recordnumber=88;
  dbms_output.put_line(mytable.currentdate);
end;