a, b and c have the same value, x is different. create synonym tq84_dual for dual;
select
sys.dbms_sqltune_util0.sqltext_to_signature('select * from dual') a,
sys.dbms_sqltune_util0.sqltext_to_signature('SELECT * FROM DUAL') b,
sys.dbms_sqltune_util0.sqltext_to_signature('SELECT * ' || chr(10) || ' from dual') c,
sys.dbms_sqltune_util0.sqltext_to_signature('SELECT * FROM tq84_dual') z
from
dual;