ORACLE|타입(TYPE, ROWTYPE), 커서(CURSOR)

PACKGAE ... ()

AS

CURSOR CUR_TABLE (

P_AAA TABLE_A.AAA%TYPE

,P_BBB TABLE_A.BBB%TYPE

) 

IS

SELECT  ...

 FROM TABLE_A A

  INNER JOIN TABLE_B B

  ON A.AAA = B.AAA

WHERE A.AAA = P_AAA

  AND A.BBB = P_BBB

;

rTABLE_A        CUR_TABLE_A%ROWTYPE;

BEGIN

OPEN CUR_TABLE( iAAA

  ,iBBB

 );

FETCH CUR_TABLE INTO rTABLE_A;

CLOSE CUR_TABLE;

            

END;