APM_PACKAGE_VERSION_INFO
Columns
| Name | Type | Nullable | Insertable | Updatable | Deletable | Comment |
|---|
| PACKAGE_KEY | VARCHAR2(100.0) | N | NO | NO | NO | |
| PACKAGE_URL | VARCHAR2(1500.0) | N | NO | NO | NO | |
| VERSION_ID | NUMBER(38) | N | YES | YES | YES | |
| PACKAGE_ID | NUMBER(38) | N | YES | YES | YES | |
| PACKAGE_NAME | VARCHAR2(500.0) | N | YES | YES | YES | |
| VERSION_NAME | VARCHAR2(100.0) | N | YES | YES | YES | |
| VERSION_URL | VARCHAR2(1500.0) | N | YES | YES | YES | |
| SUMMARY | VARCHAR2(3000.0) | Y | YES | YES | YES | |
| DESCRIPTION_FORMAT | VARCHAR2(100.0) | Y | YES | YES | YES | |
| DESCRIPTION | CLOB | Y | YES | YES | YES | |
| DISTRIBUTION | VARCHAR2(500.0) | Y | YES | YES | YES | |
| RELEASE_DATE | DATE | Y | YES | YES | YES | |
| VENDOR | VARCHAR2(500.0) | Y | YES | YES | YES | |
| VENDOR_URL | VARCHAR2(1500.0) | Y | YES | YES | YES | |
| PACKAGE_GROUP | VARCHAR2(100.0) | Y | YES | YES | YES | |
| ENABLED_P | CHAR(1.0) | N | YES | YES | YES | |
| INSTALLED_P | CHAR(1.0) | N | YES | YES | YES | |
| TAGGED_P | CHAR(1.0) | N | YES | YES | YES | |
| IMPORTED_P | CHAR(1.0) | N | YES | YES | YES | |
| DATA_MODEL_LOADED_P | CHAR(1.0) | N | YES | YES | YES | |
| ACTIVATION_DATE | DATE | Y | YES | YES | YES | |
| DEACTIVATION_DATE | DATE | Y | YES | YES | YES | |
| TARBALL_LENGTH | NUMBER(38) | Y | NO | NO | NO | |
| DISTRIBUTION_URL | VARCHAR2(1500.0) | Y | YES | YES | YES | |
| DISTRIBUTION_DATE | DATE | Y | YES | YES | YES | |
Query:
select p.package_key, p.package_url, v.version_id, v.package_id, v.package_name, v.version_name,
v.version_url, v.summary, v.description_format, v.description, v.distribution, v.release_date,
v.vendor, v.vendor_url, v.package_group, v.enabled_p, v.installed_p, v.tagged_p, v.imported_p, v.data_model_loaded_p,
v.activation_date, v.deactivation_date,
dbms_lob.getlength(distribution_tarball) tarball_length,
distribution_url, distribution_date
from apm_packages p, apm_package_versions v
where v.package_id = p.package_id
Generated by OraSchemaDoc,
(c) Aram Kananov, 2002