「Oracle入門」レコード(RECORD)のサンプル
SQL構文
DECLARE TYPE CFT_USER_TYPE IS RECORD ( USERNO NUMBER NOT NULL DEFAULT 21, USERNAME VARCHAR2(10), ADDRESS VARCHAR2(50), AGE NUMBER, BIRTHDATE DATE, AUTH_CD NUMBER ); CFT_USER_RECORD CFT_USER_TYPE; BEGIN SELECT * INTO CFT_USER_RECORD FROM USER WHERE USERNO = 8008;