Confirm what version the Oracle Database is in SQL

1137475 pts.
Tags:
Oracle
Oracle Database
SQL
My partner and I are currently creating an installer for a new application. Basically, a user gets to select a data source for their configuration -> nominate what database it is. But here's what we have to do: Basically make sure that the database is Oracle / the version too (this will be done by sending a SQL Statement to the source).
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

You can use any of these statements:

SELECT *
FROM product_component_version;

SELECT * 
FROM v$version;

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: