|
OE |
||||||||||||
|
Description Columns Query Constraints Referenced by Triggers |
Description
This view shows inventories at the Bombay warehouse.
Columns
Column | Datatype | Nullable | Insertable | Updateable | Deletable | Comment |
PRODUCT_ID | NUMBER(6,0) | N | NO | NO | NO | |
PRODUCT_NAME | NVARCHAR2(250) | Y | NO | NO | NO | |
QUANTITY_ON_HAND | NUMBER(8,0) | N | NO | NO | NO |
SELECT p.product_id , p.product_name , i.quantity_on_hand FROM inventories i , warehouses w , products p WHERE p.product_id = i.product_id AND i.warehouse_id = w.warehouse_id AND w.warehouse_name = 'Bombay'