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

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

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

        SQL*Loader�A�l�w���A�L�A�j�E�[�m���E�B�E�A�E襪蹇�V�E�m�A�P�A觧�q�j���E�k�B�V�E�\�A�
        DATE�L�\�A�z�E���E�v�B�V�E襯�m�A�q�E蹇�V�E�m�A�P�A襪�q�A�}�j���E�J�E�P�E�b�A�l�v���v���v�t�n�N�T躄�
        �T�l�w���A�P�A詈�B�A���A�u�A蠅�J�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�A�B�E�j��E�J�E�P�E�b�A�l�w��A�L�A�j�j��E�k�B�V�E�\�A蹇�V�E�m�A�P�A�

�^萋��A��

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

CREATE TABLE TEST_DATA1 
( 
  SHORI_DATE      DATE 
); 

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

LOAD DATA 
INFILE * 
INTO TABLE TEST_DATA1
TRUNCATE
( 
    SHORI_DATE      POSITION(1,10)   DATE "yyyy/mm/dd"
) 
BEGINDATA 
2000/01/01

�B�B�B�B�B�B

�B�B�B�B�B�B�B�B

�v�C�B�E�v��v��v�t�n�N�T躄�l�w��A�L�A�j�j��E�k�B�V�E�\�A蹇�V�E�m�A�P�A�

�^萋��A��

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

LOAD DATA                                              
INFILE *                                                
INTO TABLE TEST_DATA                                    
TRUNCATE                                                
(                                                       
    SHORI_DATE      POSITION(1,10)                      
                    "TO_DATE(:SHORI_DATE,'yyyy/mm/dd')" 
)                                                       
BEGINDATA                                               
2000/01/01

�A�m�A�`�A蕕盞覯�t�A�}�j�A�A�N�A�q�A�n�A蠅�J�A�P�B�v
�g�t�Z錣�}�j���E�J�E�P�E�b�A�l�w���A�L�A�j�T���A蠅襪�E�A�l�A�k�A�P�A���B�n�e�A�X磴�q�L�\�n���G�P�A�P�A襪�^�A�A
�A�k�A�u�A譴�~�B�q�B�u�v���v���v�t�n�N�T躄�z�`犧遒�l�A�B�A襪�l�n���w�n�Z豺腓���A�u�A蠅�J�A�P�B�v

To Be continued.