Loads a column of the LIST OF BYTE VARYING data type from a text
    or binary file without needing to use special application code.
    The specified file is opened and each row is read and stored in
    the LIST OF BYTE VARYING column specified by the list cursor.

1  –  Environment

    You can use the INSERT statement in interactive SQL only.

2  –  Format

  INSERT INTO CURSOR ------> <cursor-name> ----+
   +--------------------<----------------------+
   +--> FILENAME --> <file-spec> -+--------------------------------+->
                                  +-> AS -+-> BINARY -------------++
                                          +-> TEXT ---------------+
                                          +-> CHARACTER VARYING --+

3  –  Arguments

3.1  –  AS

    Syntax options:

    AS BINARY | AS CHARACTER VARYING | AS TEXT

    Specifies whether the file specified with the FILENAME clause
    contains these types of data:

    o  BINARY

       Used to load unformatted data such as images and audio files.
       The contents are broken into 512 octet segments during INSERT.

    o  CHARACTER VARYING

       Used to load text but with no terminator. The contents are
       written one line to a segment.

    o  TEXT

       Used to load text, a terminator is added to each segment
       loaded. The contents are written one line to a segment with
       trailing terminators carriage return (CR) and line feed (LF).

3.2  –  FILENAME filespec

    The specification for the file that you want to load into the
    LIST OF BYTE VARYING column.

3.3  –  INSERT INTO CURSOR cursor-name

    The name of the target list cursor to which you want to add a
    list segment.

4  –  Example

    Example 1: Adding a New Row Using Data from a Text File

    SQL> -- Declare a table cursor.
    SQL> DECLARE TABLE_CURSOR
    cont> INSERT ONLY TABLE CURSOR
    cont> FOR SELECT * FROM RESUMES;
    SQL> -- Open table cursor and insert values.
    SQL> OPEN TABLE_CURSOR;
    cont> INSERT INTO CURSOR TABLE_CURSOR
    cont> VALUES ('10065', NULL);
    1 row inserted
    SQL> -- Declare a list cursor.
    SQL> DECLARE LIST_CURSOR
    cont> INSERT ONLY LIST CURSOR
    cont> FOR SELECT RESUME WHERE CURRENT OF TABLE_CURSOR;
    SQL --Open list cursor.
    SQL> OPEN LIST_CURSOR;
    SQL> --Load text from file into LIST OF BYTE VARYING column.
    SQL> INSERT INTO CURSOR LIST_CURSOR
    cont> FILENAME 'resume_10065.sql' AS TEXT;
    SQL> CLOSE LIST_CURSOR;
    SQL> CLOSE TABLE_CURSOR;
    SQL> COMMIT;