verhint.sql
code:sql
set lines 200
set verify off
col VERSION for a9
col HINT_NAME for a30
col INVERSE for a30
col CLASS for a30
col SQL_FEATURE for a30
break on VERSION skip page
compute count of HINT_NAME on HINT_NAME
SELECT VERSION,NAME HINT_NAME,INVERSE,CLASS,SQL_FEATURE
FROM V$SQL_HINT
ORDER BY
TO_NUMBER(REGEXP_REPLACE(REGEXP_REPLACE(VERSION,'\.','',1,2),'\.','',1,2),99.999) DESC
,CLASS,NAME;
undefine 1 HINTNM
@default_settings