--
--  Name: sqlarea_hash.sql
--  
--  Parms: 
--     #1: hash_value of SQL
--
--  Description: SQL - Display statement with a specific hash value from v$sqlarea
--
--  Compatability: 7.3 and above
--
--  Usage: @topN_queries
--
select sql_text 
from v$sqlarea 
where hash_value = '&&1';