SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Getting Product Version and Edition infromation using SQL

748337May 10 2010 — edited May 11 2010

Hi Ya, I'm trying to get my Oracle database properties so I could display in my product's about dialog. For example, info like database production version and edition etc.
I know in SQL Server we have SERVERPROPERTY('ProductVersion'), SERVERPROPERTY('Edition').
Do we have something similar in Oracle too?. How can I get this info using sql in Oracle

I'm developing on Oracle 10g Express, but app runs on 10g R2 SE/EE

Cheers

PS: If I have posed my question in wrong forum, could you please point me to the correct forum.

This post has been answered by Mark Williams-Oracle on May 10 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 8 2010

Added on May 10 2010

5 comments

1,053 views