aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
fn_doorlock_roomno
Parameters
Name
Type
Mode
i_room_id
integer
IN
Definition
SELECT CASE WHEN fn_doorlock_demo_mode() THEN '101' ELSE fn_room_number(i_room_id) END