SQL Queries - CAST Management Base - How to get custom SQL statements from specific tools

Purpose of Query

The query run on the CAST management base will provide the list of custom SQL statements that are run from any of the external tools.

Applicable CAST Version

ReleaseYes/No
8.3.x✅
8.2.x✅

Applicable RDBMS

RDBMSYes/No
Oracle Server❓
Microsoft SQL Server❓
CSS2✅
CSS3✅

Query for CSS

SELECT aj.Object_Name,
       dft.Field_Value
FROM   CMS_DynamicFields_TEXT dft
       JOIN
              (SELECT Object_ID,
                      Object_Name
              FROM    CMS_TOOL_SqlBefore
               
              UNION ALL
               
              SELECT Object_ID,
                     Object_Name
              FROM   CMS_TOOL_SqlAfter
               
              UNION ALL
               
              SELECT Mode_ID,
                     Object_Name
              FROM   CMS_TOOL_KbUpdate
              )
              aj
       ON     aj.Object_ID = dft.Object_ID;

Query result example

“SQL1”;“Select * from sys_package_version;”

Query result interpretation

The result of the query provides the defined name of the tool and the queries being run.

Query for Oracle

Enter the SQL query

Query result example

Query result interpretation

Query for SQL server

Enter the SQL query

Query result example

Query result interpretation

Notes/comments

Related Pages