PL/SQL类型使用

--%Type的使用
names D401.D401_02%TYPE;

--%RowType的使用
DECLARE
  userInfo D401%ROWTYPE;
BEGIN
  SELECT * INTO userInfo FROM d401 WHERE d401_02 = 'ss ;
  dbms_output.put_line(userInfo.d401_02);
END;

--Record的使用
DECLARE
TYPE dType IS RECORD(
     a varchar2(20),
     b varchar2(20),
     c varchar2(20));
adress_record dType;
BEGIN
   SELECT d3.d301_01,d3.d301_03,d3.d301_04 INTO adress_record FROM d301 d3 WHERE d301_01 = '1059637';
   dbms_output.put_line(adress_record.a);
   dbms_output.put_line(adress_record.b);
   dbms_output.put_line(adress_record.c);
END;