Create a Quarantine Configuration for a SQL Statement by SQL Text

--
-- Create a Quarantine Configuration for a SQL Statement by SQL Text
--
 
DECLARE
    quarantine_config VARCHAR2(30);
BEGIN
    quarantine_config := DBMS_SQLQ.CREATE_QUARANTINE_BY_SQL_TEXT(
                            SQL_TEXT => to_clob('select count(*) from myTab'));
END;
/

Note
Be warned. The quarantine configuration is applied to all the execution of the SQL Test

---

Published 1st April 2022