RHNSTORAGEDEVICE
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 | |
| PHYSICAL | VARCHAR2(256) | Y | YES | YES | YES | |
| LOGICAL | 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.pcitype
from rhnDevice d
where d.class in ('HD', 'FLOPPY')