RHNHWDEVICE
DDL scriptColumns
| Name | Type | Nullable | Insertable | Updatable | Deletable | Comment |
|---|
| ID | NUMBER(38) | N | YES | YES | YES | |
| SERVER_ID | NUMBER(38) | N | YES | YES | YES | |
| CLASS | VARCHAR2(16) | Y | YES | YES | YES | |
| BUS | VARCHAR2(16) | Y | YES | YES | YES | |
| DETACHED | NUMBER(38) | Y | YES | YES | YES | |
| DEVICE | VARCHAR2(256) | Y | YES | YES | YES | |
| DRIVER | VARCHAR2(256) | Y | YES | YES | YES | |
| DESCRIPTION | VARCHAR2(256) | Y | YES | YES | YES | |
| VENDOR_ID | VARCHAR2(256) | Y | YES | YES | YES | |
| DEVICE_ID | VARCHAR2(256) | Y | YES | YES | YES | |
| SUBVENDOR_ID | VARCHAR2(256) | Y | YES | YES | YES | |
| SUBDEVICE_ID | VARCHAR2(256) | Y | YES | YES | YES | |
| PCITYPE | NUMBER(38) | Y | YES | YES | YES | |
Query:
Legend: string keyword reserved word operator
select
d.id,
d.server_Id,
d.class,
d.bus,
d.detached,
d.device,
d.driver,
d.description,
d.prop1,
d.prop2,
d.prop3,
d.prop4,
d.pcitype
from rhnDevice d
where d.class in ('AUDIO', 'MODEM', 'MOUSE', 'NETWORK',
'SCSI', 'OTHER', 'USB', 'VIDEO', 'CAPTURE',
'SCANNER', 'TAPE', 'RAID', 'SOCKET')