Páginas

segunda-feira, 25 de julho de 2016

[Oracle] - Identificando a versão do Oracle Database


Bom pessoal, essa aqui é uma dica rápida para verificar a versão do Oracle Database que está utilizando e a versão de produtos correlacionados ao mesmo:

Queries : 
select *
from v$version;

select *
from product_component_version;
Results : 
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production PL/SQL Release 11.1.0.6.0 - Production CORE 11.1.0.6.0 Production TNS for Solaris: Version 11.1.0.6.0 - Production NLSRTL Version 11.1.0.6.0 - Production
PRODUCTVERSIONSTATUS
NLSRTL11.1.0.6.0Production
Oracle Database 11g Enterprise Edition11.1.0.6.064bit Production
PL/SQL11.1.0.6.0Production
TNS for Solaris:11.1.0.6.0Production

Espero que essa postagem ajude a outros profissionais.

Links consultados:
https://docs.oracle.com/cd/B28359_01/server.111/b28310/dba004.htm
http://jasonvogel.blogspot.com.br/2008/08/getting-current-oracle-version-sql.html

Um comentário:

  1. Fairlawn Tool uses exact strategies for stamping, forming, bending, shearing, punching, welding and finishing with accuracy and consistency on your distinctive specs. In sheet metallic fabrication, endeavor tensile tests or tensile strength tests is necessary because of|as a end result of} it Professional Pet Haircutting Scissors predicts the reproducibility of a given product. This is particularly helpful for the mass manufacturing of metallic goods, wherein each product have to have} relatively the same measurements for tensile strength.

    ResponderExcluir