■예 12_1_4  ||  TAB_DEBTOR_LIST 채무 테이블에 데이터 입력
INSERT INTO TAB_DEBTOR_LIST(DEBTOR_LIST_NO
                           ,DEBTOR_LIST_TEL
                           ,DEBTOR_LIST_PHONE
                           ,DEBTOR_LIST_POSTAL
                           ,DEBTOR_LIST_ADDRESS_1
                           ,DEBTOR_LIST_ADDRESS_2
                           ,DEBTOR_LIST_REGIST_DATE
                           ,DEBTOR_LIST_INPUT
                           ,DEBTOR_LIST_MGR_NUM)
VALUES ('2013040901'
 ,'01011111111'
 ,'01011111111'
 ,'135-011'
 ,'서울 강남구 논현1동'
 ,'11'
 ,SYSDATE
 ,'2013032901'
 ,'2013032901');

■예 12_1_5  ||  TAB_BAK_LIST
SELECT DEBTOR_LIST_NO, DEBTOR_BAK_SEQ,
       DEBTOR_BAK_TEL, DEBTOR_BAK_PHONE,
       DEBTOR_BAK_ZIPCODE, DEBTOR_BAK_ADDRESS_1,
       DEBTOR_BAK_ADDRESS_2, DEBTOR_BAK_REGIST_DATE,
       DEBTOR_BAK_INPUT, DEBTOR_BAK_MGR_NUM
 FROM TAB_DEBTOR_BAK;

■예 12_1_6  ||  TAB_DEBTOR_LIST 데이터 수정
UPDATE TAB_DEBTOR_LIST
SET DEBTOR_LIST_TEL='01099999999',
     DEBTOR_LIST_MGR_NUM = '2013032104’
WHERE DEBTOR_LIST_NO = '2013040901';

■예 12_1_7  ||  수정 데이터 TAB_DEBTOR_HISTORY 입력 확인
SELECT DEBTOR_LIST_NO, DEBTOR_BAK_SEQ,
       DEBTOR_BAK_TEL, DEBTOR_BAK_PHONE,
       DEBTOR_BAK_ZIPCODE, DEBTOR_BAK_ADDRESS_1,
       DEBTOR_BAK_ADDRESS_2, DEBTOR_BAK_REGIST_DATE,
       DEBTOR_BAK_INPUT, DEBTOR_BAK_MGR_NUM
FROM TAB_DEBTOR_BAK;

■예 12_2_1  ||  init.ora 확인
/*
# db_file_multiblock_read_count = 8
#SMALL
#db_file_multiblock_read_count = 16
#MEDIUM
#db_file_multiblock_read_count = 32
#LARGE
#Datawarehouse
db_block_size=8192                  
# Transaction processing
# db_block_size=4096                  
open_cursors=300
#Transaction processing
*/

■예 12_2_2  ||  테이블 생성 예
____CREATE TABLE____ LEEOK.A_MENU_PGM
(
  MENU_ID VARCHAR2(20 BYTE) NOT NULL,
  PGM_ID VARCHAR2(20 BYTE) NOT NULL,
  DESCRIPTION VARCHAR2(200 BYTE)
)
TABLESPACE SYSTEM
PCTUSED    60
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE  (
            INITIAL          256K
            NEXT             1M
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            FREELISTS        1
            FREELIST GROUPS  1
            BUFFER_POOL      DEFAULT
           )
LOGGING
NOCOMPRESS
NOCACHE
NOPARALLEL
MONITORING;