Explore Courses Blog Tutorials Interview Questions
0 votes
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.7k 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

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

Browse Categories