kalo emang filenya gede, pake sqlloader aja
On 3/8/07, A. Baso Annas <[EMAIL PROTECTED]> wrote:
>
> login sebagai sys, kemudian grant read permission ke user;
>
> SQL >CREATE DIRECTORY DIR_FILE AS 'D:/TEMPORARY';
>
> SQL > GRANT READ ON DIRECTORY DIR_FILE TO MDNETWORK;
>
> SQL > connect mdnetwork/mdnetwork;
>
> SQL > SET SERVEROUTPUT ON;
>
> SQL> DECLARE
> 2 V1 VARCHAR2(32767);
> 3 F1 UTL_FILE.FILE_TYPE;
> 4 BEGIN
> 5 F1 := UTL_FILE.FOPEN('DIR_FILE', 'TEST.txt', 'R');
> 6
> 7 LOOP
> 8 UTL_FILE.GET_LINE(F1, V1);
> 9 DBMS_OUTPUT.put_line(V1);
> 10 END LOOP;
> 11 EXCEPTION
> 12 WHEN NO_DATA_FOUND THEN
> 13 UTL_FILE.FCLOSE(F1);
> 14 END;
> 15 /
> 1;IWAN
> 2;BUDI
> 3;BLA-BLA
>
> PL/SQL procedure successfully completed.
>
> SQL>
>
> [Non-text portions of this message have been removed]
>
>
>
[Non-text portions of this message have been removed]
