34 lines
1.0 KiB
MySQL
34 lines
1.0 KiB
MySQL
-- 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.
|
|
|
|
--------------------------------------------------------------------------------
|
|
--
|
|
-- File name: sqlfh.sql (SQL Feature Hieararchy)
|
|
--
|
|
-- Purpose: Display the full SQL Feature Hieararchy from v$sql_feature
|
|
--
|
|
-- Author: Tanel Poder
|
|
-- Copyright: (c) http://www.tanelpoder.com
|
|
--
|
|
-- Usage: @sqlfh
|
|
--
|
|
-- Other: Requires Oracle 11g+
|
|
--
|
|
--------------------------------------------------------------------------------
|
|
|
|
COL sqlfh_feature HEAD SQL_FEATURE FOR A55
|
|
|
|
PROMPT Display full SQL Feature Hierarchy from v$sql_feature ...
|
|
SELECT
|
|
LPAD(' ', (level-1)*2) || REPLACE(f.sql_feature, 'QKSFM_','') sqlfh_feature
|
|
, f.description
|
|
FROM
|
|
v$sql_feature f
|
|
, v$sql_feature_hierarchy fh
|
|
WHERE
|
|
f.sql_feature = fh.sql_feature
|
|
CONNECT BY fh.parent_id = PRIOR f.sql_Feature
|
|
START WITH fh.sql_feature = 'QKSFM_ALL'
|
|
/
|
|
|