The FCOPY stored procedure is used to copy text lines within a specified range from the source file to the target file.
Applicability
This content applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support it.
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 |
Explanation |
|---|---|
| src_location | The name of the directory object where the source file is located. |
| src_filename | The name of the source file. |
| dest_location | The name of the directory object where the target file is located. |
| dest_filename | The name of the target file. |
| start_line | The row number at which the copy starts. Default value is1. |
| end_line | The row number at which the copy ends. Default value:NULL. |