ORACE pl/sql记录(RECORD)

DECLARE

    TYPE RECO_TYPE IS RECORD

    (

         ID T_TABLE.ID%TYPE,

         NAME T_TABLE.NAME%TYPE,

         DESCRIPTION T_TABLE.DESCRIBE%TYPE

     );

     MY_TYPE RECO_TYPE;

BEGIN

     SELECT ID,NAME,DESCRIPTION INTO MY_TYPE FROM T_TABLE WHERE ID=&ID;

     DBMS_OUTPUT.PUT_LINE(MY_TYPE.ID);

     DBMS_OUTPUT.PUT_LINE(MY_TYPE.NAME);

     DBMS_OUTPUT.PUT_LINE(MY_TYPE.DESCRIPTION);

END;

转载于:https://www.cnblogs.com/fantinglhx/archive/2011/02/27/1966209.html