Tabular Forms - Expert Oracle Application Express - page 157

THEN
SELECT dept seq.NEXTVAL
INTO :NEW.deptno
FROM DUAL;
END IF;
END;
/
CREATE OR REPLACE TRIGGER emp tr
BEFORE INSERT
ON emp
FOR EACH ROW
BEGIN
IF :NEW.empno IS NULL
THEN
SELECT emp seq.NEXTVAL
INTO :NEW.empno
FROM DUAL;
END IF;
END;
/
Now, editing the Report Attributes and the newly created column properties for the column VALID
you can change Display As to Simple Checkbox as shown in Figure 3-2.
Figure 3-2. Using Simple Checkbox item type
Using the List of Values tab you will need to enter the required static LOV for a simple checkbox (see
Figure 3-3). If you require only one value, you will need to change the list of values definition to Y instead
of Y,N.