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

�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�C

�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�v�A�A�g�A�z�P猝��E�k�B�V�E�\�A�J�A衒��A�A�A�j�[貶�q�A�}
�j��L�\�A�q�n��G�P�A�L�A�\�E�k�B�V�E�\�A發��[貶�q�A�}�k�b�i��A�q�n��G�P�A�L�A�\�E�k�B�V�E�\�A蹇�V�E�m�A�P�A襦�v

�^萋��A��

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

CREATE TABLE TEST_DATA2                                 
(                                                       
    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_DATA2                                   
TRUNCATE                                                
(                                                       
    SHORI_DATE      POSITION(01:10)                     
                    "TO_DATE(:SHORI_DATE,'yyyy/mm/dd')",
    SHORI_NENDO     "TO_CHAR(ADD_MONTHS(TO_DATE         
                  (:SHORI_DATE,'yyyy/mm/dd'),-3),'yyyy')"
)                                                       
BEGINDATA                                               
2000/01/01

SHORI_NENDO �A�}�v���v���v�t�n�N�T躄�kDATE�L�\�A�q�n���G�P�A�I�A譴�\�E�k�B�V�E�\�A���E�n�k�V�A�I�A譴�J�A�P�B�v
SHORI_NENDO �A�}�v���v���v�t�n�N�T躄�k�k�b�i���B�n�v�G�L遒�}�G�l�A�L�A�j�B�q�A�q�n���G�P�A�I�A譴�j
�^�Z�z�z�k�b�v�G�L紊���E�n�k�V�A�I�A譴�J�A�P�B�v

To Be continued.