query for oracle versione code example

Example: check oracle version

SELECT * FROM v$version;