Page tree
Skip to end of metadata
Go to start of metadata
Purpose of Query

 The query checks if there is an installed TCC tool kit and returns the version of the tool

Applicable CAST Version

 

Release
Yes/No
8.3.x (tick) 
8.2.x (tick) 
8.1.x (tick) 
8.0.x (tick) 
Applicable RDBMS

 

RDBMS
Yes/No
Oracle Server (tick) 
Microsoft SQL Server (tick) 
CSS2 (tick) 


Query for CSS
SELECT version 
FROM   sys_package_version 
WHERE  package_name = 'TCK_LOCAL'; 
Query result example
 1.7.1.0".
Query result interpretation
 The query returns the version of the installed TCC tool kit
Query for Oracle
SELECT version  
FROM   sys_package_version 
WHERE  package_name = 'TCK_LOCAL'; 
Query result example
 "1.7.1.0".
Query result interpretation
  The query returns the version of the installed TCC tool kit
Query for SQL server
SELECT version 
FROM   sys_package_version 
WHERE  package_name = 'TCK_LOCAL'; 
Query result example
 "1.7.1.0".
Query result interpretation
  The query returns the version of the installed TCC tool kit
Notes/comments
 

 

 

Related Pages
 
  • No labels