pagila
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
inventory_held_by_customer
Parameters
Name
Type
Mode
p_inventory_id
integer
IN
Definition
DECLARE v_customer_id INTEGER; BEGIN SELECT customer_id INTO v_customer_id FROM rental WHERE return_date IS NULL AND inventory_id = p_inventory_id; RETURN v_customer_id; END