In article <b4nc6j$4hj$1_at_cronkite.cc.uga.edu>, jeff_at_work.com (Jeff) wrote:
>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.
Whoops. You're right, SQLplus does show the database's version banner after
you connect. But in my defense, I usually run sqlplus with the /nolog switch
and connect manually, which does NOT show the usual banner after connecting.
:-)
Received on Wed Mar 12 2003 - 07:33:23 CST
