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