16 lines
685 B
SQL
16 lines
685 B
SQL
-- Copyright 2018 Tanel Poder. All rights reserved. More info at http://tanelpoder.com
|
|
-- Licensed under the Apache License, Version 2.0. See LICENSE.txt for terms & conditions.
|
|
--
|
|
-- Explain AutoTask names such as: ORA$AT_OS_OPT_SY_6809
|
|
|
|
COL task_class FOR A40
|
|
COL task_operation FOR A40
|
|
COL task_type FOR A40
|
|
|
|
SELECT
|
|
(SELECT cname_ketcl FROM x$ketcl WHERE ctag_ketcl = REGEXP_SUBSTR('&1', '([[:alnum:]]+)', 1, 3)) task_class
|
|
, (SELECT opname_ketop FROM x$ketop WHERE otag_ketop = REGEXP_SUBSTR('&1', '([[:alnum:]]+)', 1, 4)) task_operation
|
|
, (SELECT tname_kettg FROM x$kettg WHERE ttag_kettg = REGEXP_SUBSTR('&1', '([[:alnum:]]+)', 1, 5)) task_type
|
|
FROM dual
|
|
/
|