使用Oracle 10g保存和检索二进制文件的最佳方法是什么？

CREATE TABLE binary_files (
    id NUMBER PRIMARY KEY,
    file_name VARCHAR2(255),
    file_type VARCHAR2(50),
    file_size NUMBER,
    creation_date DATE
);

CREATE TABLE binary_files (
    id NUMBER PRIMARY KEY,
    file_name VARCHAR2(255),
    file_type VARCHAR2(50),
    file_size NUMBER,
    creation_date DATE,
    file_content BLOB
);

INSERT INTO binary_files (id, file_name, file_type, file_size, creation_date, file_content)
VALUES (1, 'example.jpg', 'image/jpeg', 34567, SYSDATE, EMPTY_BLOB());

DECLARE
    file_content BLOB := empty_blob();
    file_loc BFILE := BFILENAME('MY_DIRECTORY', 'example.jpg');
BEGIN
    INSERT INTO binary_files (id, file_name, file_type, file_size, creation_date, file_content)
    VALUES (1, 'example.jpg', 'image/jpeg', 34567, SYSDATE, file_content)
    RETURN file_content INTO file_content;

    DBMS_LOB.FILEOPEN(file_loc, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.LOADFROMFILE(file_content, file_loc, DBMS_LOB.LOBMAXSIZE);
    DBMS_LOB.FILECLOSE(file_loc);
END;

SELECT file_content
FROM binary_files
WHERE id = 1;

DECLARE
    file_content BLOB;
    file_loc BFILE := BFILENAME('MY_DIRECTORY', 'retrieved_example.jpg');
BEGIN
    SELECT file_content
    INTO file_content
    FROM binary_files
    WHERE id = 1;

    DBMS_LOB.FILEOPEN(file_loc, DBMS_LOB.LOB_READWRITE);
    DBMS_LOB.WRITE(file_loc, file_content, DBMS_LOB.LOBMAXSIZE);
    DBMS_LOB.FILECLOSE(file_loc);
END;