RHNPACKAGECHANGELOG
DDL scriptColumns
| Name | Type | Nullable | Insertable | Updatable | Deletable | Comment |
|---|
| ID | NUMBER(38) | N | YES | YES | YES | |
| PACKAGE_ID | NUMBER(38) | N | YES | YES | YES | |
| CHANGELOG_DATA_ID | NUMBER(38) | N | YES | YES | YES | |
| NAME | VARCHAR2(128) | N | NO | NO | NO | |
| TEXT | VARCHAR2(3000) | N | NO | NO | NO | |
| TIME | TIMESTAMP(6) WITH LOCAL TIME ZONE | N | NO | NO | NO | |
| CREATED | TIMESTAMP(6) WITH LOCAL TIME ZONE | N | YES | YES | YES | |
| MODIFIED | TIMESTAMP(6) WITH LOCAL TIME ZONE | N | YES | YES | YES | |
Query:
Legend: string keyword reserved word operator
select rhnPackageChangeLogRec.id,
rhnPackageChangeLogRec.package_id,
rhnPackageChangeLogRec.changelog_data_id,
rhnPackageChangeLogData.name,
rhnPackageChangeLogData.text,
rhnPackageChangeLogData.time,
rhnPackageChangeLogRec.created,
rhnPackageChangeLogRec.modified
from rhnPackageChangeLogRec, rhnPackageChangeLogData
where rhnPackageChangeLogRec.changelog_data_id = rhnPackageChangeLogData.id