Get Oracle version from a production server using SQL Developer

There are several ways to do this depending on what privileges you have and what tools you are using. This is one way:

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

The blog My Digital Life presents a few other alternatives:

http://www.mydigitallife.info/2005/10/18/check-oracle-version/