DBA Data[Home] [Help]

VIEW: SYS.DBA_AUTOTASK_STATUS

Source

View Text - Preformatted

SELECT DECODE(STATUS,  2, 'ENABLED',  1, 'DISABLED', 3, 'ALLOWED',
              'INVALID') AS STATUS,
        LAST_CHANGE
  FROM KET$_CLIENT_CONFIG
 WHERE CLIENT_ID = 0
View Text - HTML Formatted

SELECT DECODE(STATUS
, 2
, 'ENABLED'
, 1
, 'DISABLED'
, 3
, 'ALLOWED'
, 'INVALID') AS STATUS
, LAST_CHANGE
FROM KET$_CLIENT_CONFIG
WHERE CLIENT_ID = 0