Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to check which version of Oracle

 
gurusamy sengodan
Ranch Hand
Posts: 41
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
How to check which version of Oracle installed on the machine?
 
Mark Spritzler
ranger
Sheriff
Posts: 17278
6
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Client or Server, Windows or Linux/UNIX? On WIndows CLient, you can always go to START-PROGRAMS-ORACLE and look at one of the applications that are loaded by Oracle and check the Help menu of that program? Or something just like that. or command line sqlplus, that must have the Oracle version when you first log in.

Mark
 
Avi Abrami
Ranch Hand
Posts: 1141
1
Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator


Good Luck,
Avi.
 
Benjamin Lau
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
How do I get the version from the code?
 
Avi Abrami
Ranch Hand
Posts: 1141
1
Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Benjamin,
Pardon my ignorance, but what code are you referring to?
.NET
java
C++
PL/SQL
other

Good Luck,
Avi.
 
Benjamin Lau
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Avi,

java or PL/SQL

Thanks!

Benjamin
 
Avi Abrami
Ranch Hand
Posts: 1141
1
Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Benjamin,
Using PL/SQL:

With java, use the appropriate methods in the DatabaseMetaData interface.

Good Luck,
Avi.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic