摘要：
DECLARE TYPE C1 IS REF CURSOR; V_CURSOR C1; V_NAME T_TABLE.NAME%TYPE; V_DESC T_TABLE.DESCRIPTION %TYPE;BEGIN OPEN V_CURSOR FOR SELECT NAME,DESCRIPTION FROM T_TABLE; LOOP FETCH V_CURSOR INTO V_NAME,V_DESC; EXIT WHEN V_CURSOR%NOTFOUND; DBMS_OUTPUT.PUT_LINE(V_NAME ||'--------'|| V_DESC); END LO 阅读全文
摘要：
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_LIN 阅读全文