APM_FILE_INFO
Columns
| Name | Type | Nullable | Insertable | Updatable | Deletable | Comment |
|---|
| FILE_ID | NUMBER(38) | N | YES | YES | YES | |
| VERSION_ID | NUMBER(38) | N | YES | YES | YES | |
| PATH | VARCHAR2(1500.0) | N | YES | YES | YES | |
| FILE_TYPE | VARCHAR2(50.0) | Y | YES | YES | YES | |
| PACKAGE_KEY | VARCHAR2(100.0) | N | NO | NO | NO | |
| FULL_PATH | VARCHAR2(1610.0) | Y | NO | NO | NO | |
Query:
select f.*, p.package_key, 'packages/' || p.package_key || '/' || f.path full_path
from apm_package_files f, apm_package_versions v, apm_packages p
where f.version_id = v.version_id
and v.package_id = p.package_id
Generated by OraSchemaDoc,
(c) Aram Kananov, 2002