verhintsel.sql
code:sql
define HINTNM=&1
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
SELECT VERSION,NAME HINT_NAME,INVERSE,CLASS,SQL_FEATURE
FROM V$SQL_HINT
WHERE upper(NAME) like '%' || upper('&HINTNM') || '%'
ORDER BY
TO_NUMBER(REGEXP_REPLACE(REGEXP_REPLACE(VERSION,'\.','',1,2),'\.','',1,2),99.999) DESC
,NAME;
undefine 1 HINTNM
@default_settings