0 votes
1 view
in SQL by (20.3k points)

I'm building an installer for an application. The user gets to select a data source they have configured and nominate what type of database it is. I want to confirm that the database type is indeed Oracle, and if possible, what version of Oracle they are running by sending a SQL statement to the data source.

1 Answer

0 votes
by (40.3k points)

Try to run the SQL as follows:

select * from v$version;

And you'll get the result like this:



Oracle Database 10g Release - 64bit Production

PL/SQL Release - Production

CORE      Production

TNS for Solaris: Version - Production

NLSRTL Version - Production

Related questions

Welcome to Intellipaat Community. Get your technical queries answered by top developers !