FCOPY copies lines from start_line to end_line (inclusive) from the source file to the destination file.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support this feature.
Syntax
UTL_FILE.FCOPY (
src_location IN VARCHAR2,
src_filename IN VARCHAR2,
dest_location IN VARCHAR2,
dest_filename IN VARCHAR2,
start_line IN BINARY_INTEGER DEFAULT 1,
end_line IN BINARY_INTEGER DEFAULT NULL
);
Parameters
| Parameter | Description |
|---|---|
| src_location | The alias of the directory where the source file is located. |
| src_filename | The name of the source file to be copied. |
| dest_location | The alias of the directory where the destination file is located. |
| dest_filename | The name of the destination file to be created or overwritten. |
| start_line | The line number from which to start copying. Default value: 1. |
| end_line | The line number to which to copy. |