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
| Release | Yes/No |
|---|---|
| 8.2.x | ✅ |
| 8.1.x | ✅ |
| 8.0.x | ✅ |
Applicable RDBMS
| RDBMS | Yes/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 Name | Version |
| /com.castsoftware.cfamily | 1.1.0-funcrel |
| /com.castsoftware.dmtxcodediscoverer | 1.1.0 |
| /com.castsoftware.ios | 1.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