get oracle version code example

Example 1: oracle how to know version

SELECT * FROM v$version
WHERE banner LIKE 'Oracle%';

Example 2: oracle db version query

SELECT * FROM v$version;