ORACLE中的%ROWTYPE

1.变量赋值

  

create or replace procedure pro_testis type v_a_count is record(    a NUMBER,    b varchar2(50));v_a_countInfo v_a_count; ---------这个需要注意beginselect 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_testis 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;