recordtypedefine.sql

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

set serveroutput on
declare
   type myrecord is record(
      myrecordnumber int,
      mycurrentdate date);
   srecord myrecord;
begin
   select  *  into  srecord   from  tempuser.testtable  where recordnumber=68;
   dbms_output.put_line(srecord.mycurrentdate);
end;