|
OE |
||||||||||||
|
|
|||||||||||||
| Description Columns Query Constraints Referenced by Triggers |
| Column | Datatype | Nullable | Insertable | Updateable | Deletable | Comment |
| PRODUCT_ID | NUMBER(6,0) | Y | YES | YES | YES | |
| WAREHOUSE | WAREHOUSE_TYP(100) | Y | YES | YES | YES | |
| QUANTITY_ON_HAND | NUMBER(8,0) | Y | YES | YES | YES |
SELECT i.product_id,
warehouse_typ(w.warehouse_id, w.warehouse_name, w.location_id),
i.quantity_on_hand
FROM inventories i, warehouses w
WHERE i.warehouse_id=w.warehouse_id