file_info: Multi-platform OS File Metadata Properties
read only
- Catalog:
FileSystem - Label: File Metadata Properties
Can only retrieve data.
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
ignore_ |
varchar2 |
Whether to ignore errors when accessing the file. Defaults to false. | ||
path |
varchar2 |
Relative or absolute path to the file. |
Table Columns
The columns of the table file_info 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 |
|---|---|---|---|---|---|
created |
datetime |
Created | fetched only when named | ||
created_ |
datetime |
Created (UTC) | fetched only when named | ||
directory_ |
varchar2 |
Directory Name | fetched only when named | ||
exception_ |
varchar2 |
Exception Code | fetched only when named | The message code of the error. | |
exception_ |
varchar2 |
Exception Message | fetched only when named | The text of the error. | |
extension |
varchar2 |
Extension | fetched only when named | ||
is_ |
varchar2 |
Is Archive File | fetched only when named | ||
is_ |
varchar2 |
Is Compressed File | fetched only when named | ||
is_ |
varchar2 |
Is Content Indexed File | fetched only when named | ||
is_ |
varchar2 |
Is Device File | fetched only when named | ||
is_ |
varchar2 |
Is Directory | fetched only when named | ||
is_ |
varchar2 |
Is Encrypted File | fetched only when named | ||
is_ |
varchar2 |
Is Existing | fetched only when named | ||
is_ |
varchar2 |
Is Hidden File | fetched only when named | ||
is_ |
varchar2 |
Is Integrity Stream File | fetched only when named | ||
is_ |
varchar2 |
Is Normal File | fetched only when named | ||
is_ |
varchar2 |
Is Offline File | fetched only when named | ||
is_ |
varchar2 |
Is Reparse Point File | fetched only when named | ||
is_ |
varchar2 |
Is Scrub Data File | fetched only when named | ||
is_ |
varchar2 |
Is Sparse File | fetched only when named | ||
is_ |
varchar2 |
Is System File | fetched only when named | ||
is_ |
varchar2 |
Is Temporary File | fetched only when named | ||
is_ |
varchar2 |
Is Writable File | fetched only when named | ||
last_ |
datetime |
Last Access | fetched only when named | ||
last_ |
datetime |
Last Access (UTC) | fetched only when named | ||
last_ |
datetime |
{res:itgen_last_write | fetched only when named | ||
last_ |
datetime |
Last Write (UTC) | fetched only when named | ||
length |
number |
File Size (bytes) | fetched only when named | ||
name |
varchar2 |
Name | fetched only when named |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: