Determine Oracle DB Version

To determine the running oracle version
execute the following sql stmt :

select * from v$version where banner like 'Oracle%';