Database Reference
In-Depth Information
ROUND(sysdate - t.created_on)
open_or_pending,
NVL(ROUND(t.closed_on - t.created_on),0)
closed,
sl.status status
FROM
tickets t,
status_lookup sl
WHERE
t.status_id = sl.status_id
and t.ticket_id = :P210_TICKET_ID)
Figure 8-26.
Entering the SQL statement for a computation
15.
Optionally, move the Days Open counter next to the Subject using drag and
drop within the tree. You can then position them on the same line by editing
P210_DAYS_OPEN
and setting the
Start New Row
attribute to
No
.
Fig-
ure 8-27
shows the element in its new position.
