SQL> set serveroutput on
SQL> DECLARE
CURSOR cur IS
SELECT DATA_DATE,
ACCT_NO ,
ACCT_ORD ,
ACCT_NO_PK ,
CARD_CODE ,
CUST_NO ,
BANK_CORP_CODE,
MGR_CODE ,
BRAN_CODE ,
SUB_CODE ,
CUR_CODE ,
TERM ,
TERM_FLAG ,
ACCT_BAL ,
OPEN_DATE ,
START_INT_DATE,
DUE_DATE ,
CANCEL_DATE ,
NOR_INT_RATE ,
ACCT_ATTR_NAME,
BUSI_NAME ,
ACCT_STATUS ,
FLAG
from T_PM_DEPOSIT_HIS;
BEGIN
FOR row IN cur LOOP
DBMS_OUTPUT.PUT_LINE('last name: ' || row.ACCT_NO || '--' ||row.OPEN_DATE);
END LOOP;
END; 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
SQL> DECLARE
CURSOR cur IS
SELECT DATA_DATE,
ACCT_NO ,
ACCT_ORD ,
ACCT_NO_PK ,
CARD_CODE ,
CUST_NO ,
BANK_CORP_CODE,
MGR_CODE ,
BRAN_CODE ,
SUB_CODE ,
CUR_CODE ,
TERM ,
TERM_FLAG ,
ACCT_BAL ,
OPEN_DATE ,
START_INT_DATE,
DUE_DATE ,
CANCEL_DATE ,
NOR_INT_RATE ,
ACCT_ATTR_NAME,
BUSI_NAME ,
ACCT_STATUS ,
FLAG
from T_PM_DEPOSIT_HIS;
BEGIN
FOR row IN cur LOOP
DBMS_OUTPUT.PUT_LINE('last name: ' || row.ACCT_NO || '--' ||row.OPEN_DATE);
END LOOP;
END; 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23