ORACLE中的%ROWTYPE

1.变量赋值

  

create or replace procedure pro_test
is
 
type v_a_count is record(
    a NUMBER,
    b varchar2(50));
v_a_countInfo v_a_count; ---------这个需要注意
begin

select a,b into v_a_countInfo from a_count ;

  
dbms_output.put_line(v_a_countInfo.a||v_a_countInfo.a);

 
dbms_output.put_line('没有数据');
 
end;

 

2.

create or replace procedure pro_test
is
 v_RoomRecord a_count%ROWTYPE;
begin
  
select * into v_RoomRecord from a_count where a=1;

insert into a_count values ( v_RoomRecord.a,v_RoomRecord.b);
commit;
 
end;