| Name | Type | Nullable | Insertable | Updatable | Deletable | Comment |
|---|---|---|---|---|---|---|
| SERVER_ID | NUMBER(38) | N | NO | NO | NO | |
| ERRATA_ID | NUMBER(38) | Y | NO | NO | NO | |
| ERRATA_TYPE | VARCHAR2(32) | N | NO | NO | NO | |
| PACKAGE_COUNT | NUMBER(38) | Y | NO | NO | NO |
Legend: comment string keyword reserved word operator
SELECT SNPC.server_id, SNPC.errata_id, E.advisory_type, COUNT(SNPC.package_id) FROM rhnErrata E, rhnServerNeededPackageCache SNPC WHERE E.id = SNPC.errata_id GROUP BY SNPC.server_id, SNPC.errata_id, E.advisory_type