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
Release | Yes/No |
|---|---|
| 8.3.x |  |
| 8.2.x |  |
Applicable RDBMS
RDBMS | Yes/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