SQL Queries - Common SQL Queries - How to get the list of installed extensions

Created by user-4b453 on Feb 11, 2022
Purpose of Query

This page provides query to get the list of Extensions that have been installed / managed on the triplet.

Applicable CAST Version
Release
Yes/No
8.2.x(tick)
8.1.x(tick)
8.0.x(tick)
Applicable RDBMS
RDBMS
Yes/No
Oracle Server(tick)
Microsoft SQL Server(question)
CSS2(tick)
Query for CSS
SELECT package_name, 
       version 
FROM   sys_package_version 
WHERE  package_name LIKE '/%' 
ORDER  BY package_name;  

 

 

Query result example
Package NameVersion
/com.castsoftware.cfamily1.1.0-funcrel
/com.castsoftware.dmtxcodediscoverer1.1.0
/com.castsoftware.ios1.1.0-funcrel
Query result interpretation

 In that example, there are 3 extensions installed :

CFamily Extension. The version is 1.1.0 funcrel

XCodediscoverer. The version is 1.1.0

ios Extension. The version is 1.1.0 funcrel

 

 

 

Notes/comments
 

 

 

Related Pages