SQL*Loader�A��l�w��A�L�A�j�j��E�k�B�V�E�\�A��G�P�A�P�A詈��B�v�E

�B�B�B�B�B�B�B�B�B�B �B�B�E��B�V�E爐�q�t瓩� �B�B

SQL*Loader�A�l�w��A�L�A�j�j��E�k�B�V�E�\�A��G�P�A�P�A詈�B�v�E

�B�B�B�B
        �B� �^癲�B�t�^ �B�

�B�B�B�B�B�B�B�BSQL*Loader�A�l�w���A�L�A�j�E�[�m���E�B�E�A�E襪蹇�V�E�m�A�P�A觧�q�v���v���v�t�n�N�T躄�
�B�B�B�B�B�B�B�B�T�l�w���A�P�A襪�l�A�A�A蹐�A�A蹐�n�n���P�P�A�e�A�B�A�g�A�g�E蹇�V�E�m�A���C�g�k�X�A�k�A�P�B�v

        �B� �V�  �n�t �B�

        SQL*Loader
        
        �B� �G�g  �J�� �B�

        NT , UNIX ( ORACLE �I���A�� SQL*Loader �A���T�l�w���C�g�k�X�A�n�G�g�J���`�G�A�j )

�v��v��v�t�n�N�T躄�l�w��A�L�A�j�E蹇�V�E�m�A�P�A觜猝��E�k�B�V�E�\�A��E�P�E��B�V�E�P�A�z�T�u
NULL�A�q�e��A��G�P�A�B�A�j�E�j�B�V�E��E襪�q�E�n�k�V�A�P�A詈�B�A�k�A�P�B�v
�B�n�A�E�A�z�n�B�A�}�E�J�E�q�E絅�u�E襪篁��l�z�A�z�X��A�q�I��X��A�I�A譴�j�A�A�A�J�A�P�B�q

�^萋��A��

/* �E蹇�V�E�m�E�j�E�P�E�l�w���E�j�B�V�E���E襪鄒�� */

CREATE TABLE TEST_DATA3                                 
(                                                       
    SHORI_DATE      DATE,                               
    SHORI_NENDO     CHAR(4)                             
);                                                      

/* �E蹇�V�E�m�w���^�D�N罐���E�B�E�A�E� */

LOAD DATA                                               
INFILE *                                                
INTO TABLE TEST_DATA3                                   
TRUNCATE                                                
(                                                       
    SHORI_DATE  POSITION(01:10)                         
                NULLIF SHORI_DATE=BLANKS                
                "TO_DATE(:SHORI_DATE,'yyyy/mm/dd')",    
    SHORI_NENDO NULLIF SHORI_DATE=BLANKS                
                "TO_CHAR(ADD_MONTHS(TO_DATE             
                (:SHORI_DATE,'yyyy/mm/dd'),-3),'yyyy')" 
)                                                       
BEGINDATA                                               
2000/01/01@                                             
          @                                             
2000/04/01@

�X萢睛�j�A�} SQL*Loader�A�l�w���A�L�A�j�j���E�k�B�V�E�\�A���G�P�A�P�A詈�B�v�E �A�q�E���E薀�b
�T�q NULL �A�q�e���A���G�P�A�B�A�j�E�n�k�V�A�P�A覽�B�k�X�A���A�A�C�e�A�B�A�\�A發�z�A�k�A�P�B�v
NULLIF �A�k�Z錣�q�[戝���A�P�A觧� NULL�A�q�e���A���G�P�A�B�A襪茲���A�q�A�L�Z錣�} �E蹇�V�E�m�A�P�A�
�P猝��A�� BLANKS �A�k�A�u�A訃豺腓�l�A�L�A�J�A�P�B�v

�n簑���B�@�E蹇�V�E�m�E�k�B�V�E�\�A�z�R�k�N紊�z@�A�}�E�k�B�V�E�\�A�z�J萓���A蠅襪茲���A�q�A�P�A覦��
      �m���C�e�A�L�A�j�A�A�A�J�A�P

To Be continued.