20 lines
579 B
SQL
20 lines
579 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.
|
|
|
|
COL hintf_name FOR A35
|
|
|
|
select
|
|
name hintf_name
|
|
, sql_feature
|
|
, version
|
|
, version_outline
|
|
, decode(bitand(target_level,1),1,'STATEMENT ') ||
|
|
decode(bitand(target_level,2),2,'QBLOCK ') ||
|
|
decode(bitand(target_level,4),4,'OBJECT ') ||
|
|
decode(bitand(target_level,8),8,'JOIN ') hint_scope
|
|
from
|
|
v$sql_hint
|
|
where
|
|
lower(sql_feature) like lower('%&1%')
|
|
/
|