{"id":29,"date":"2009-12-02T22:16:42","date_gmt":"2009-12-02T22:16:42","guid":{"rendered":"http:\/\/oracle-internals.com\/blog\/?p=29"},"modified":"2014-01-26T22:17:09","modified_gmt":"2014-01-26T22:17:09","slug":"nextgres-gateway-sqlplus-teaser","status":"publish","type":"post","link":"https:\/\/oracle-internals.com\/blog\/2009\/12\/02\/nextgres-gateway-sqlplus-teaser\/","title":{"rendered":"NEXTGRES Gateway SQL*Plus Teaser\u2026"},"content":{"rendered":"<p>Do you love SQL*Plus but hate that you can\u2019t use it with other, non-Oracle databases?\u00a0 Do you wish you could more easily migrate some of your MySQL or Postgres applications to Oracle?\u00a0 If so, stay tuned, because my next few blog entries are going to show you how to do just that.\u00a0 But first, I want to throw a little teaser out there for the SQL*Plus crowd\u2026<\/p>\n<p>Let\u2019s face it, SQL*Plus is an awesome tool.\u00a0 And, it\u2019s a tool everyone who\u2019s had to manage databases from multiple RDBMS vendors wishes they could use against all of them.\u00a0 Well, if you\u2019re using Postgres, MySQL, SQL Server, or DB2 and are tired of using cheap, JDBC-driven SQL*Plus knock-offs, my next blog entry will show you how to interface the\u00a0<em>real<\/em>\u00a0SQL*Plus with each of those systems using nothing but Instant Client, a couple libraries, and a little ingenuity.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Do you love SQL*Plus but hate that you can\u2019t use it with other, non-Oracle databases?\u00a0 Do you wish you could more easily migrate some of your MySQL or Postgres applications to Oracle?\u00a0 If so, stay tuned, because my next few blog entries are going to show you how to do just that.\u00a0 But first, I [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>NEXTGRES Gateway SQL*Plus Teaser\u2026 - Oracle Internals<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/oracle-internals.com\/blog\/2009\/12\/02\/nextgres-gateway-sqlplus-teaser\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"NEXTGRES Gateway SQL*Plus Teaser\u2026 - Oracle Internals\" \/>\n<meta property=\"og:description\" content=\"Do you love SQL*Plus but hate that you can\u2019t use it with other, non-Oracle databases?\u00a0 Do you wish you could more easily migrate some of your MySQL or Postgres applications to Oracle?\u00a0 If so, stay tuned, because my next few blog entries are going to show you how to do just that.\u00a0 But first, I [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"http:\/\/oracle-internals.com\/blog\/2009\/12\/02\/nextgres-gateway-sqlplus-teaser\/\" \/>\n<meta property=\"og:site_name\" content=\"Oracle Internals\" \/>\n<meta property=\"article:published_time\" content=\"2009-12-02T22:16:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2014-01-26T22:17:09+00:00\" \/>\n<meta name=\"author\" content=\"Jonah Harris\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@jonahharris\" \/>\n<meta name=\"twitter:site\" content=\"@jonahharris\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jonah Harris\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\/\/oracle-internals.com\/blog\/2009\/12\/02\/nextgres-gateway-sqlplus-teaser\/#article\",\"isPartOf\":{\"@id\":\"http:\/\/oracle-internals.com\/blog\/2009\/12\/02\/nextgres-gateway-sqlplus-teaser\/\"},\"author\":{\"name\":\"Jonah Harris\",\"@id\":\"http:\/\/oracle-internals.com\/blog\/#\/schema\/person\/549d9c522c3960b062618b600bb762a4\"},\"headline\":\"NEXTGRES Gateway SQL*Plus Teaser\u2026\",\"datePublished\":\"2009-12-02T22:16:42+00:00\",\"dateModified\":\"2014-01-26T22:17:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\/\/oracle-internals.com\/blog\/2009\/12\/02\/nextgres-gateway-sqlplus-teaser\/\"},\"wordCount\":161,\"commentCount\":0,\"publisher\":{\"@id\":\"http:\/\/oracle-internals.com\/blog\/#\/schema\/person\/549d9c522c3960b062618b600bb762a4\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"http:\/\/oracle-internals.com\/blog\/2009\/12\/02\/nextgres-gateway-sqlplus-teaser\/\",\"url\":\"http:\/\/oracle-internals.com\/blog\/2009\/12\/02\/nextgres-gateway-sqlplus-teaser\/\",\"name\":\"NEXTGRES Gateway SQL*Plus Teaser\u2026 - Oracle Internals\",\"isPartOf\":{\"@id\":\"http:\/\/oracle-internals.com\/blog\/#website\"},\"datePublished\":\"2009-12-02T22:16:42+00:00\",\"dateModified\":\"2014-01-26T22:17:09+00:00\",\"breadcrumb\":{\"@id\":\"http:\/\/oracle-internals.com\/blog\/2009\/12\/02\/nextgres-gateway-sqlplus-teaser\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/oracle-internals.com\/blog\/2009\/12\/02\/nextgres-gateway-sqlplus-teaser\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/oracle-internals.com\/blog\/2009\/12\/02\/nextgres-gateway-sqlplus-teaser\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\/\/oracle-internals.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"NEXTGRES Gateway SQL*Plus Teaser\u2026\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\/\/oracle-internals.com\/blog\/#website\",\"url\":\"http:\/\/oracle-internals.com\/blog\/\",\"name\":\"Oracle Internals\",\"description\":\"Researching the Inner Workings of the World&#039;s Most Powerful Database\",\"publisher\":{\"@id\":\"http:\/\/oracle-internals.com\/blog\/#\/schema\/person\/549d9c522c3960b062618b600bb762a4\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/oracle-internals.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"http:\/\/oracle-internals.com\/blog\/#\/schema\/person\/549d9c522c3960b062618b600bb762a4\",\"name\":\"Jonah Harris\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/oracle-internals.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a6d16ed0f510e8de0929f129471dc1e5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a6d16ed0f510e8de0929f129471dc1e5?s=96&d=mm&r=g\",\"caption\":\"Jonah Harris\"},\"logo\":{\"@id\":\"http:\/\/oracle-internals.com\/blog\/#\/schema\/person\/image\/\"},\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/jonahharris\/\",\"https:\/\/x.com\/jonahharris\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"NEXTGRES Gateway SQL*Plus Teaser\u2026 - Oracle Internals","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"http:\/\/oracle-internals.com\/blog\/2009\/12\/02\/nextgres-gateway-sqlplus-teaser\/","og_locale":"en_US","og_type":"article","og_title":"NEXTGRES Gateway SQL*Plus Teaser\u2026 - Oracle Internals","og_description":"Do you love SQL*Plus but hate that you can\u2019t use it with other, non-Oracle databases?\u00a0 Do you wish you could more easily migrate some of your MySQL or Postgres applications to Oracle?\u00a0 If so, stay tuned, because my next few blog entries are going to show you how to do just that.\u00a0 But first, I [&hellip;]","og_url":"http:\/\/oracle-internals.com\/blog\/2009\/12\/02\/nextgres-gateway-sqlplus-teaser\/","og_site_name":"Oracle Internals","article_published_time":"2009-12-02T22:16:42+00:00","article_modified_time":"2014-01-26T22:17:09+00:00","author":"Jonah Harris","twitter_card":"summary_large_image","twitter_creator":"@jonahharris","twitter_site":"@jonahharris","twitter_misc":{"Written by":"Jonah Harris","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/oracle-internals.com\/blog\/2009\/12\/02\/nextgres-gateway-sqlplus-teaser\/#article","isPartOf":{"@id":"http:\/\/oracle-internals.com\/blog\/2009\/12\/02\/nextgres-gateway-sqlplus-teaser\/"},"author":{"name":"Jonah Harris","@id":"http:\/\/oracle-internals.com\/blog\/#\/schema\/person\/549d9c522c3960b062618b600bb762a4"},"headline":"NEXTGRES Gateway SQL*Plus Teaser\u2026","datePublished":"2009-12-02T22:16:42+00:00","dateModified":"2014-01-26T22:17:09+00:00","mainEntityOfPage":{"@id":"http:\/\/oracle-internals.com\/blog\/2009\/12\/02\/nextgres-gateway-sqlplus-teaser\/"},"wordCount":161,"commentCount":0,"publisher":{"@id":"http:\/\/oracle-internals.com\/blog\/#\/schema\/person\/549d9c522c3960b062618b600bb762a4"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"http:\/\/oracle-internals.com\/blog\/2009\/12\/02\/nextgres-gateway-sqlplus-teaser\/","url":"http:\/\/oracle-internals.com\/blog\/2009\/12\/02\/nextgres-gateway-sqlplus-teaser\/","name":"NEXTGRES Gateway SQL*Plus Teaser\u2026 - Oracle Internals","isPartOf":{"@id":"http:\/\/oracle-internals.com\/blog\/#website"},"datePublished":"2009-12-02T22:16:42+00:00","dateModified":"2014-01-26T22:17:09+00:00","breadcrumb":{"@id":"http:\/\/oracle-internals.com\/blog\/2009\/12\/02\/nextgres-gateway-sqlplus-teaser\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/oracle-internals.com\/blog\/2009\/12\/02\/nextgres-gateway-sqlplus-teaser\/"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/oracle-internals.com\/blog\/2009\/12\/02\/nextgres-gateway-sqlplus-teaser\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/oracle-internals.com\/blog\/"},{"@type":"ListItem","position":2,"name":"NEXTGRES Gateway SQL*Plus Teaser\u2026"}]},{"@type":"WebSite","@id":"http:\/\/oracle-internals.com\/blog\/#website","url":"http:\/\/oracle-internals.com\/blog\/","name":"Oracle Internals","description":"Researching the Inner Workings of the World&#039;s Most Powerful Database","publisher":{"@id":"http:\/\/oracle-internals.com\/blog\/#\/schema\/person\/549d9c522c3960b062618b600bb762a4"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/oracle-internals.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"http:\/\/oracle-internals.com\/blog\/#\/schema\/person\/549d9c522c3960b062618b600bb762a4","name":"Jonah Harris","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/oracle-internals.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/a6d16ed0f510e8de0929f129471dc1e5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a6d16ed0f510e8de0929f129471dc1e5?s=96&d=mm&r=g","caption":"Jonah Harris"},"logo":{"@id":"http:\/\/oracle-internals.com\/blog\/#\/schema\/person\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/in\/jonahharris\/","https:\/\/x.com\/jonahharris"]}]}},"_links":{"self":[{"href":"https:\/\/oracle-internals.com\/blog\/wp-json\/wp\/v2\/posts\/29"}],"collection":[{"href":"https:\/\/oracle-internals.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oracle-internals.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oracle-internals.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oracle-internals.com\/blog\/wp-json\/wp\/v2\/comments?post=29"}],"version-history":[{"count":1,"href":"https:\/\/oracle-internals.com\/blog\/wp-json\/wp\/v2\/posts\/29\/revisions"}],"predecessor-version":[{"id":30,"href":"https:\/\/oracle-internals.com\/blog\/wp-json\/wp\/v2\/posts\/29\/revisions\/30"}],"wp:attachment":[{"href":"https:\/\/oracle-internals.com\/blog\/wp-json\/wp\/v2\/media?parent=29"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oracle-internals.com\/blog\/wp-json\/wp\/v2\/categories?post=29"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oracle-internals.com\/blog\/wp-json\/wp\/v2\/tags?post=29"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}