Login | Register
The inventory_function function returns a boolean value indicating whether the inventory item specified is in stock.
inventory_function
p_inventory_id: The ID of the inventory item to be checked.
p_inventory_id
This function returns TRUE or FALSE to indicate whether the item specified is in stock.
TRUE
FALSE
mysql> SELECT inventory_in_stock(9); +-----------------------+ | inventory_in_stock(9) | +-----------------------+ | 0 | +-----------------------+ 1 row in set (0.03 sec) mysql> SELECT inventory_in_stock(8); +-----------------------+ | inventory_in_stock(8) | +-----------------------+ | 1 | +-----------------------+ 1 row in set (0.00 sec)
SELECT inventory_in_stock(9);
SELECT inventory_in_stock(8);
© 2013, Oracle Corporation and/or its affiliates
