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

Purpose of Query

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

Applicable CAST Version

ReleaseYes/No
8.2.x
8.1.x
8.0.x

Applicable RDBMS

RDBMSYes/No
Oracle Server
Microsoft SQL Server
CSS2

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