Oracle Forms supplies six special default values $$DATE$$, $$DATETIME$$, $$TIME$$, $$DBDATE$$, $$DBDATETIME$$, and $$DBTIME$$ that supply date and time information. These variables have the and the following special restrictions on their use:
Assume that you want to create a Key-NXTBLK trigger at the form level that navigates depending on what the current block is. The following trigger performs this function, using :SYSTEM.CURSOR_BLOCK stored in a local variable:
DECLARE
curblk VARCHAR2(30);
BEGIN
curblk := :System.Cursor_Block;
IF curblk = 'Orders'
THEN Go_Block('Items');
ELSIF curblk = 'Items'
THEN Go_Block('Customers');
ELSIF curblk = 'Customers'
THEN Go_Block('Orders');
END IF;
END;
All system variables are case-sensitive, and most return their arguments as uppercase values. This will affect the way you compare results in IF statements.