oracle中rowtype,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;