APM_ENABLED_PACKAGE_VERSIONS
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 "PACKAGE_KEY","PACKAGE_URL","VERSION_ID","PACKAGE_ID","PACKAGE_NAME","VERSION_NAME","VERSION_URL","SUMMARY","DESCRIPTION_FORMAT","DESCRIPTION","DISTRIBUTION","RELEASE_DATE","VENDOR","VENDOR_URL","PACKAGE_GROUP","ENABLED_P","INSTALLED_P","TAGGED_P","IMPORTED_P","DATA_MODEL_LOADED_P","ACTIVATION_DATE","DEACTIVATION_DATE","TARBALL_LENGTH","DISTRIBUTION_URL","DISTRIBUTION_DATE" from apm_package_version_info
where enabled_p = 't'
Generated by OraSchemaDoc,
(c) Aram Kananov, 2002