{"id":746,"date":"2013-10-08T15:02:53","date_gmt":"2013-10-08T15:02:53","guid":{"rendered":"http:\/\/putridparrot.com\/blog\/?p=746"},"modified":"2013-10-08T15:02:53","modified_gmt":"2013-10-08T15:02:53","slug":"what-version-of-oracle-am-i-connecting-to","status":"publish","type":"post","link":"https:\/\/putridparrot.com\/blog\/what-version-of-oracle-am-i-connecting-to\/","title":{"rendered":"What version of Oracle am I connecting to ?"},"content":{"rendered":"<p>We recently moved from using Oracle 10g to Oracle 11g<\/p>\n<p><em>Note: I have access to the DB in this scenario but only via Oracle SQL Developer<\/em><\/p>\n<p>I wanted to verify that the version I was connecting to was indeed 11g, so found this<\/p>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\r\nSELECT * FROM PRODUCT_COMPONENT_VERSION;\r\n<\/pre>\n<p>Which returns the following<\/p>\n[table \u201c\u201d not found \/]<br \/>\n\n","protected":false},"excerpt":{"rendered":"<p>We recently moved from using Oracle 10g to Oracle 11g Note: I have access to the DB in this scenario but only via Oracle SQL Developer I wanted to verify that the version I was connecting to was indeed 11g, so found this SELECT * FROM PRODUCT_COMPONENT_VERSION; Which returns the following<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[22,52],"tags":[],"class_list":["post-746","post","type-post","status-publish","format-standard","hentry","category-database","category-oracle"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/posts\/746","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/comments?post=746"}],"version-history":[{"count":2,"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/posts\/746\/revisions"}],"predecessor-version":[{"id":748,"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/posts\/746\/revisions\/748"}],"wp:attachment":[{"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/media?parent=746"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/categories?post=746"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/tags?post=746"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}