RHNORGPACKAGEOVERVIEW
DDL scriptColumns
| Name | Type | Nullable | Insertable | Updatable | Deletable | Comment |
|---|
| ORG_ID | NUMBER(38) | Y | NO | NO | NO | |
| CHANNEL_ARCH_ID | NUMBER(38) | N | NO | NO | NO | |
| PACKAGE_ID | NUMBER(38) | N | NO | NO | NO | |
| PACKAGE_NVREA | VARCHAR2(4000) | Y | NO | NO | NO | |
Query:
Legend: string keyword reserved word operator
select
p.org_id org_id,
cpac.channel_arch_id,
p.id package_id,
rhn_package.canonical_name(p_name.name, p_evr.evr, pa.name) package_nvrea
from
rhnPackageName p_name,
rhnPackageEVR p_evr,
rhnPackageArch pa,
rhnChannelPackageArchCompat cpac,
rhnPackage p
where
p_name.id = p.name_id
and p_evr.id = p.evr_id
and cpac.package_arch_id = p.package_arch_id
and p.package_arch_id = pa.id
order by package_nvrea, p.created