Clears the value from the current text item, regardless of the current cursor position, and changes the text item value to NULL.
Built-in Type restricted procedure
Enter Query Mode yes
/*
** Built-in: CLEAR_ITEM
** Example: Clear the current item if it does not represent
** the first day of a month.
** Trigger: When-New-Item-Instance
*/
BEGIN
IF TO_CHAR(:Emp.Hiredate,'DD') <> '01' THEN
Clear_Item;
Message('This date must be of the form 01-MON-YY');
END IF;
END;