Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Checking the server version
In article <8SOdncTU37JOvPOjXTWcjA_at_giganews.com>, "Gabriel Gonzalez" <no-spam_at_no-spam.com> wrote:
>Easiest? Connect with SQLPlus, you'll see the banner that tells the
>version... you can also query the data dictionary, but you gotta connect
>first.
That tells you the version of SQLPlus, which may or may not be current to the database. The best way to get the database version, IMHO, is to query v$version. If you cannot connect, you can also find the version in the alert log... assuming the database has ever been started at all. Received on Wed Mar 12 2003 - 07:20:17 CST