read_file_text: Multi-platform OS File Text Contents
read only
- Catalog:
FileSystem - Label: File Text Contents
Can only retrieve data.
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
encoding |
varchar2 |
Character encoding, defaults to UTF8, alternative names listed in code page table on https://docs.microsoft.com/en-us/dotnet/api/system.text.encoding?view=netframework-4.8. | ||
ignore_ |
varchar2 |
Whether to ignore errors when accessing the file. Defaults to false. | ||
path |
varchar2 |
Relative or absolute path to the file. | ||
record_ |
varchar2 |
Record separator is a text signaling the start of a new record. Defaults to platform-specific new line. | ||
separate_ |
varchar2 |
Separates file contents into records based upon the record separator when true. Returns full file contents as one large text when false. Defaults to false. |
Table Columns
The columns of the table read_file_text are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
file_ |
clob |
File Contents | fetched only when named | ||
file_ |
varchar2 |
Filename and Path | fetched only when named | ||
is_ |
varchar2 |
Is Existing | fetched only when named |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: