tabletypedefine2.sql

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

Declare
  type tabletype1 is table of testtable%rowtype index by binary_integer;
  table1 tabletype1;
begin
  select * into table1(60)
  from tempuser.testtable
  where recordnumber=60;
  dbms_output.put_line(table1(60).recordnumber||table1(60).currentdate);
end;