{"id":26,"date":"2022-08-27T12:42:17","date_gmt":"2022-08-27T15:42:17","guid":{"rendered":"https:\/\/kappasoft.com.br\/wiki\/?p=26"},"modified":"2022-09-22T12:14:31","modified_gmt":"2022-09-22T15:14:31","slug":"como-descobrir-a-versao-do-oracle","status":"publish","type":"post","link":"https:\/\/kappasoft.com.br\/wiki\/2022\/08\/27\/como-descobrir-a-versao-do-oracle\/","title":{"rendered":"Como descobrir a vers\u00e3o do ORACLE"},"content":{"rendered":"\n<p>Segue abaixo um script interessante que mostra a vers\u00e3o e as options presentes na instala\u00e7\u00e3o.<\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;showPanel&quot;:true,&quot;languageLabel&quot;:&quot;language&quot;,&quot;fullScreenButton&quot;:true,&quot;copyButton&quot;:true,&quot;mode&quot;:&quot;sql&quot;,&quot;mime&quot;:&quot;text\/x-sql&quot;,&quot;theme&quot;:&quot;material&quot;,&quot;lineNumbers&quot;:false,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:false,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;&quot;,&quot;language&quot;:&quot;SQL&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;sql&quot;}\">SQL&gt; set head off feed off pages 0 serveroutput on\nSQL&gt; col banner format a100 wrap\n\nSQL&gt; select banner\n\t from   sys.v_$version;\n\n--Verifica as Options instaladas\nSQL&gt; select '   Com instalada: '||parameter||';'\n\t from   sys.v_$option\n\t where  value = 'TRUE';\n\n--Verifica as Options n\u00e3o instaladas\nSQL&gt; select '   Option n\u00e3o instalada: '||parameter||';'\n\t from   sys.v_$option\n\t where  value &amp;lt;&amp;gt; 'TRUE';\n\n--Verifica a vers\u00e3o do ORACLE, se x86_64 ... e a vers\u00e3o do KERNEL do Linux\nSQL&gt; begin\n    \tdbms_output.put_line('Tipo ORACLE\/Vers\u00e3o Kernel Linux: '||dbms_utility.port_string);\n\t end;\n\t \/<\/pre><\/div>\n\n\n\n<p>Um exemplo da sa\u00edda da execu\u00e7\u00e3o<\/p>\n\n\n","protected":false},"excerpt":{"rendered":"<p>Segue abaixo um script interessante que mostra a vers\u00e3o e as options presentes na instala\u00e7\u00e3o. Um exemplo da sa\u00edda da execu\u00e7\u00e3o<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,2],"tags":[],"class_list":["post-26","post","type-post","status-publish","format-standard","hentry","category-banco-de-dados","category-oracle"],"_links":{"self":[{"href":"https:\/\/kappasoft.com.br\/wiki\/wp-json\/wp\/v2\/posts\/26","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kappasoft.com.br\/wiki\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kappasoft.com.br\/wiki\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kappasoft.com.br\/wiki\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kappasoft.com.br\/wiki\/wp-json\/wp\/v2\/comments?post=26"}],"version-history":[{"count":5,"href":"https:\/\/kappasoft.com.br\/wiki\/wp-json\/wp\/v2\/posts\/26\/revisions"}],"predecessor-version":[{"id":58,"href":"https:\/\/kappasoft.com.br\/wiki\/wp-json\/wp\/v2\/posts\/26\/revisions\/58"}],"wp:attachment":[{"href":"https:\/\/kappasoft.com.br\/wiki\/wp-json\/wp\/v2\/media?parent=26"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kappasoft.com.br\/wiki\/wp-json\/wp\/v2\/categories?post=26"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kappasoft.com.br\/wiki\/wp-json\/wp\/v2\/tags?post=26"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}