Oracle Database Version

Wed, 09/03/2008 - 2:07pm — Lepa

A Very simple SQL to return Oracle's database version you are currently in.

SELECT *

  FROM v$version

 WHERE ROWNUM = 1;

BANNER

Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production

Bookmark/Search this post with:

Please try to help out with unanswered topics on the forum. Chances are you have had the same issue/question some time in your IT career!

Comments

Have a question? Please ask it on the forum instead.

Your name: *

E-mail: *

The content of this field is kept private and will not be shown publicly.

Homepage:

Subject:

Comment: *

Input format

Filtered HTML

Allowed HTML tags: <div> <pre> <br> <code> <a> <em> <blockquote> <strong> <ul> <ol> <li> <dl> <dt> <b> <p> <h1> <h2> <u> <img>
Web page addresses and e-mail addresses turn into links automatically.
Lines and paragraphs break automatically.
You can enable syntax highlighting of source code with the following tags: <code>.

BBcode

Notify me when new comments are posted

CAPTCHA

The question below is to prevent automated spam submissions.

Math question: * 2 + 2 =

Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.

Title	Under	Posted on
Abs Mgmt: How can Abs rule pro-rate contractor's last month's entitlement (need help urgently)	PeopleSoft Functional	03/10/2010 - 9:21pm
Can we user LONG datatype as a search option in PeopleSoft	PeopleSoft Technical	03/10/2010 - 11:22am
special caracters are not translated correctly when ftp from windows to unix	Programming	03/09/2010 - 3:23pm
How to view the employees from particular country in peoplesoft?	PeopleSoft Technical	03/03/2010 - 1:56am