@@header

/*
*
*  Author     : Vishal Gupta
*  Purpose    : Convert SQLText to SQLID
*  Parameters : 1 - SQLText 
*               
*
*  Revision History:
*  ===================
*  Date       Author        Description
*  ---------  ------------  -----------------------------------------
*  11-Mar-15  Vishal Gupta  Created
*
*
*/

COLUMN FORCE_MATCHING_SIGNATURE FORMAT 9999999999999999999999999
COLUMN SQL_ID FORMAT a20

-------------------------------------------------
-- Convert SQLText to FORCE_MATCHING_SIGNATURE
-------------------------------------------------
SELECT sys.DBMS_SQLTUNE.SQLTEXT_TO_SIGNATURE(q'[
SELECT * FROM DUAL
]'
,force_match => 1) FORCE_MATCHING_SIGNATURE
FROM DUAL
;

/*
-------------------------------------------------
-- Convert SQLText to SQL_ID
-------------------------------------------------
SELECT sys.DBMS_SQLTUNE_UTIL0.SQLTEXT_TO_SQLID(q'[
SELECT * FROM DUAL
]') SQL_ID
FROM DUAL
;
*/

@@footer