RHNSERVEROUTDATEDPACKAGES
DDL scriptColumns
| Name | Type | Nullable | Insertable | Updatable | Deletable | Comment |
|---|
| SERVER_ID | NUMBER(38) | N | NO | NO | NO | |
| PACKAGE_NAME_ID | NUMBER(38) | N | NO | NO | NO | |
| PACKAGE_EVR_ID | NUMBER(38) | N | NO | NO | NO | |
| PACKAGE_ARCH_ID | NUMBER(38) | N | NO | NO | NO | |
| PACKAGE_NVRE | VARCHAR2(4000) | Y | NO | NO | NO | |
| ERRATA_ID | NUMBER(38) | Y | NO | NO | NO | |
| ERRATA_ADVISORY | VARCHAR2(100) | Y | NO | NO | NO | |
Query:
Legend: string keyword reserved word operator
SELECT DISTINCT SNC.server_id,
P.name_id,
P.evr_id,
P.package_arch_id,
PN.name || '-' || evr_t_as_vre_simple( PE.evr ),
E.id,
E.advisory
FROM rhnPackageName PN,
rhnPackageEVR PE,
rhnPackage P,
rhnServerNeededCache SNC
left outer join
rhnErrata E
on SNC.errata_id = E.id
WHERE SNC.package_id = P.id
AND P.name_id = PN.id
AND P.evr_id = PE.id