How can I confirm a database is Oracle what version it is using SQL

Question

I'm creating an application installer. The user chooses a datasource they've set up and specifies the kind of database it belongs to. By sending a SQL statement to the datasource, I want to make sure that the database type is Oracle and, if it's possible, what version of Oracle they are using.

Answer 1

Run this SQL:

select * from v$version;

Output:

BANNER
----------------------------------------------------------------
Oracle Database 10g Release 10.2.0.3.0 - 64bit Production
PL/SQL Release 10.2.0.3.0 - Production
CORE    10.2.0.3.0      Production
TNS for Solaris: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - Production

I hope this helps you.