% Rowtype in Oracle

1. Variable assignment

Create or replace procedure pro_testis type v_a_count is record (a number, B varchar2 (50); v_a_countinfo v_a_count; --------- this requires attention to 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 ('no data'); 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 (values, v_roomrecord. B); Commit; end;