Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle Version
select * from v$version;
On 2/11/07, rajendra.pande_at_ubs.com <rajendra.pande_at_ubs.com> wrote:
>
> Guys
>
> During upgrade, is there any query that can be used to find the existing
> version of ORACLE while the database is opened with the new
> ORACLE.binaries for upgrade.
>
> For example upgrading from 8174 to 10G the query should give 8174 while
> the database is opened with 10G - obvioulsly before the
> upgrade(catpatch) is run.
>
> -RP
>
> Thanks
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- http://www.freelists.org/webpage/oracle-lReceived on Sun Feb 11 2007 - 09:56:29 CST
![]() |
![]() |