SQL validation for timeouts in days:

SQL="SELECT decode ( timeout, 0, 'No timeout', meaning ) meaning
,      timeout
into :visible_option_value, :profile_option_value
FROM   ( SELECT TO_CHAR(level - 1)||' days'   meaning
         ,      level - 1                     timeout
         FROM   dual
         CONNECT BY LEVEL <= 11 )"
COLUMN="Meaning(15)"
HEADING="\"Timeout Days\"(15)"


--------------------------------------------------------------------------------
SQL validation for timeouts in days and hours

SQL="SELECT DECODE ( timeout_period, 0,'No timeout',meaning)   meaning
,      timeout_period
into :visible_option_value, :profile_option_value
FROM   ( SELECT CASE
                  WHEN (level-1) < 24 THEN
                    CASE WHEN (level-1) = 1 THEN '1 hour'
                    ELSE
                      TO_CHAR(level-1)||' hours'
                    END
                  ELSE
                    CASE WHEN MOD((level-1),24) = 0 THEN
                      CASE WHEN level = 25 THEN '1 day'
                      ELSE
                        TO_CHAR(TRUNC((level-1)/24))||' days'
                      END
                    ELSE
                      CASE WHEN TRUNC((level-1)/24) = 1 THEN
                        CASE WHEN MOD((level-1),24) = 1 THEN '1 day and 1 hour'
                        ELSE
                          '1 day and '||MOD((level-1),24)||' hours'
                        END
                      ELSE
                        CASE WHEN MOD((level-1),24) = 1 THEN TO_CHAR(TRUNC((level-1)/24))||' days and 1 hour'
                        ELSE
                          TO_CHAR(TRUNC((level-1)/24))||' days and '||MOD((level-1),24)||' hours'
                        END
                      END
                    END
                  END        meaning
         ,      (level-1) / 24   timeout_period
         FROM dual
         CONNECT BY LEVEL <= 241 )"
COLUMN="Meaning(15)"
HEADING="\"Timeout Period\"(15)"