Files
oracle/star/sqlid_sign.sql
2026-03-12 21:23:47 +01:00

8 lines
227 B
SQL

col FORCE_MATCHING_SIGNATURE for 99999999999999999999
select FORCE_MATCHING_SIGNATURE from gv$sql where sql_id='&&1'
union all
select FORCE_MATCHING_SIGNATURE from DBA_HIST_SQLSTAT where sql_id='&&1'
fetch first 1 rows only;