select top 1 banner || id_code from v$version;使用这个SQL查询

按语句SELECT '数据库版本：'||BANNER||' '||ID_CODE FROM V$VERSION LIMIT 0,1; 查询出版本号，版本号对应解释如下：

select top 1 a.banner ||'-'|| b.build_version from v$version a ,v$instance b;

用这个命令查询，视图查询会比你jdbc返回的更加详细

这样试一下

WITH version_data AS (
    SELECT 
        SUBSTR(REGEXP_SUBSTR(banner, 'V[0-9]+'), 2) AS main_version
    FROM v$version
    WHERE ROWNUM = 1
),
instance_data AS (
    SELECT 
        REGEXP_SUBSTR(build_version, '^[0-9]+') AS sub_version,
        REGEXP_SUBSTR(build_version, '[0-9]+', 1, 2) AS revision_version,
        REGEXP_SUBSTR(build_version, '[0-9]+', 1, 3) AS build_number
    FROM v$instance
)
SELECT 
    version_data.main_version || '.' || 
    instance_data.sub_version || '.' || 
    instance_data.revision_version || '.' || 
    instance_data.build_number AS combined_version
FROM version_data, instance_data;