{"id":100,"date":"2018-01-17T23:12:27","date_gmt":"2018-01-17T21:12:27","guid":{"rendered":"https:\/\/lyubomir-angelov.com\/?p=100"},"modified":"2020-02-09T19:28:18","modified_gmt":"2020-02-09T17:28:18","slug":"go-lang-oracle-ora-00933-sql-command-not-properly-ended","status":"publish","type":"post","link":"https:\/\/lyubomir-angelov.com\/blog\/go-lang-oracle-ora-00933-sql-command-not-properly-ended\/","title":{"rendered":"Go Lang Oracle &#8211; ORA-00933: SQL command not properly ended"},"content":{"rendered":"<p>While building some migrations with Goose I had some strange (for me) error, for which you can find a lot of different stuff on Google but nothing helped.<br \/>\n<!--more--><br \/>\nThe error was like in the title: <strong>&#8220;ORA-00933: SQL command not properly ended&#8221;<\/strong> for this query<\/p>\n<pre class=\"language-sql\"><code>\nUPDATE table1 SET title = CONCAT(&#039;FORMER-&#039;, title) WHERE id &lt;= 500;\n<\/code><\/pre>\n<p>This query will work without problems in SQL editor like Oracle SQL Developer but not in the GO Goose adapter<\/p>\n<p>The reason for this error is the <strong>space between the comma and title column in the CONCAT function<\/strong> and <strong>the semicolon &#8220;;&#8221; at the end<\/strong>, so the query should be like this:<\/p>\n<pre class=\"language-sql\"><code> UPDATE table1 SET title = CONCAT(&#039;FORMER-&#039;,title) WHERE id &lt;= 500<\/code><\/pre>\n<p>Small tips: don&#8217;t use space between params in the functions and don&#8217;t add a semicolon \ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":"<p>While building some migrations with Goose I had some strange (for me) error, for which you can find a lot of different stuff on Google but nothing helped.<\/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":[16,18,17],"class_list":["post-100","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-go-lang","tag-goose","tag-oracle"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Go Lang Oracle - ORA-00933: SQL command not properly ended - Lyubomir Angelov<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/lyubomir-angelov.com\/blog\/go-lang-oracle-ora-00933-sql-command-not-properly-ended\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Go Lang Oracle - ORA-00933: SQL command not properly ended - Lyubomir Angelov\" \/>\n<meta property=\"og:description\" content=\"While building some migrations with Goose I had some strange (for me) error, for which you can find a lot of different stuff on Google but nothing helped.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/lyubomir-angelov.com\/blog\/go-lang-oracle-ora-00933-sql-command-not-properly-ended\/\" \/>\n<meta property=\"og:site_name\" content=\"Lyubomir Angelov\" \/>\n<meta property=\"article:published_time\" content=\"2018-01-17T21:12:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-02-09T17:28:18+00:00\" \/>\n<meta name=\"author\" content=\"Lyubomir\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@angelovcode\" \/>\n<meta name=\"twitter:site\" content=\"@angelovcode\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Lyubomir\" \/>\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\":\"https:\/\/lyubomir-angelov.com\/blog\/go-lang-oracle-ora-00933-sql-command-not-properly-ended\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/lyubomir-angelov.com\/blog\/go-lang-oracle-ora-00933-sql-command-not-properly-ended\/\"},\"author\":{\"name\":\"Lyubomir\",\"@id\":\"https:\/\/lyubomir-angelov.com\/blog\/#\/schema\/person\/5e091f5c2fa79f57d30d482a7ef8cd92\"},\"headline\":\"Go Lang Oracle &#8211; ORA-00933: SQL command not properly ended\",\"datePublished\":\"2018-01-17T21:12:27+00:00\",\"dateModified\":\"2020-02-09T17:28:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/lyubomir-angelov.com\/blog\/go-lang-oracle-ora-00933-sql-command-not-properly-ended\/\"},\"wordCount\":122,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/lyubomir-angelov.com\/blog\/#\/schema\/person\/5e091f5c2fa79f57d30d482a7ef8cd92\"},\"keywords\":[\"go lang\",\"goose\",\"oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/lyubomir-angelov.com\/blog\/go-lang-oracle-ora-00933-sql-command-not-properly-ended\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/lyubomir-angelov.com\/blog\/go-lang-oracle-ora-00933-sql-command-not-properly-ended\/\",\"url\":\"https:\/\/lyubomir-angelov.com\/blog\/go-lang-oracle-ora-00933-sql-command-not-properly-ended\/\",\"name\":\"Go Lang Oracle - ORA-00933: SQL command not properly ended - Lyubomir Angelov\",\"isPartOf\":{\"@id\":\"https:\/\/lyubomir-angelov.com\/blog\/#website\"},\"datePublished\":\"2018-01-17T21:12:27+00:00\",\"dateModified\":\"2020-02-09T17:28:18+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/lyubomir-angelov.com\/blog\/go-lang-oracle-ora-00933-sql-command-not-properly-ended\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/lyubomir-angelov.com\/blog\/go-lang-oracle-ora-00933-sql-command-not-properly-ended\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/lyubomir-angelov.com\/blog\/go-lang-oracle-ora-00933-sql-command-not-properly-ended\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/lyubomir-angelov.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Go Lang Oracle &#8211; ORA-00933: SQL command not properly ended\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/lyubomir-angelov.com\/blog\/#website\",\"url\":\"https:\/\/lyubomir-angelov.com\/blog\/\",\"name\":\"Lyubomir Angelov\",\"description\":\"The life of a Manager\",\"publisher\":{\"@id\":\"https:\/\/lyubomir-angelov.com\/blog\/#\/schema\/person\/5e091f5c2fa79f57d30d482a7ef8cd92\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/lyubomir-angelov.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/lyubomir-angelov.com\/blog\/#\/schema\/person\/5e091f5c2fa79f57d30d482a7ef8cd92\",\"name\":\"Lyubomir\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/lyubomir-angelov.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f6b8c15868355fa857fad18647aeadd07814e3d9baa72a1c92e718056684fec7?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f6b8c15868355fa857fad18647aeadd07814e3d9baa72a1c92e718056684fec7?s=96&d=mm&r=g\",\"caption\":\"Lyubomir\"},\"logo\":{\"@id\":\"https:\/\/lyubomir-angelov.com\/blog\/#\/schema\/person\/image\/\"},\"sameAs\":[\"https:\/\/twitter.com\/angelovcode\"],\"url\":\"https:\/\/lyubomir-angelov.com\/blog\/author\/superfly\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Go Lang Oracle - ORA-00933: SQL command not properly ended - Lyubomir Angelov","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":"https:\/\/lyubomir-angelov.com\/blog\/go-lang-oracle-ora-00933-sql-command-not-properly-ended\/","og_locale":"en_US","og_type":"article","og_title":"Go Lang Oracle - ORA-00933: SQL command not properly ended - Lyubomir Angelov","og_description":"While building some migrations with Goose I had some strange (for me) error, for which you can find a lot of different stuff on Google but nothing helped.","og_url":"https:\/\/lyubomir-angelov.com\/blog\/go-lang-oracle-ora-00933-sql-command-not-properly-ended\/","og_site_name":"Lyubomir Angelov","article_published_time":"2018-01-17T21:12:27+00:00","article_modified_time":"2020-02-09T17:28:18+00:00","author":"Lyubomir","twitter_card":"summary_large_image","twitter_creator":"@angelovcode","twitter_site":"@angelovcode","twitter_misc":{"Written by":"Lyubomir","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/lyubomir-angelov.com\/blog\/go-lang-oracle-ora-00933-sql-command-not-properly-ended\/#article","isPartOf":{"@id":"https:\/\/lyubomir-angelov.com\/blog\/go-lang-oracle-ora-00933-sql-command-not-properly-ended\/"},"author":{"name":"Lyubomir","@id":"https:\/\/lyubomir-angelov.com\/blog\/#\/schema\/person\/5e091f5c2fa79f57d30d482a7ef8cd92"},"headline":"Go Lang Oracle &#8211; ORA-00933: SQL command not properly ended","datePublished":"2018-01-17T21:12:27+00:00","dateModified":"2020-02-09T17:28:18+00:00","mainEntityOfPage":{"@id":"https:\/\/lyubomir-angelov.com\/blog\/go-lang-oracle-ora-00933-sql-command-not-properly-ended\/"},"wordCount":122,"commentCount":0,"publisher":{"@id":"https:\/\/lyubomir-angelov.com\/blog\/#\/schema\/person\/5e091f5c2fa79f57d30d482a7ef8cd92"},"keywords":["go lang","goose","oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/lyubomir-angelov.com\/blog\/go-lang-oracle-ora-00933-sql-command-not-properly-ended\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/lyubomir-angelov.com\/blog\/go-lang-oracle-ora-00933-sql-command-not-properly-ended\/","url":"https:\/\/lyubomir-angelov.com\/blog\/go-lang-oracle-ora-00933-sql-command-not-properly-ended\/","name":"Go Lang Oracle - ORA-00933: SQL command not properly ended - Lyubomir Angelov","isPartOf":{"@id":"https:\/\/lyubomir-angelov.com\/blog\/#website"},"datePublished":"2018-01-17T21:12:27+00:00","dateModified":"2020-02-09T17:28:18+00:00","breadcrumb":{"@id":"https:\/\/lyubomir-angelov.com\/blog\/go-lang-oracle-ora-00933-sql-command-not-properly-ended\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/lyubomir-angelov.com\/blog\/go-lang-oracle-ora-00933-sql-command-not-properly-ended\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/lyubomir-angelov.com\/blog\/go-lang-oracle-ora-00933-sql-command-not-properly-ended\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/lyubomir-angelov.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Go Lang Oracle &#8211; ORA-00933: SQL command not properly ended"}]},{"@type":"WebSite","@id":"https:\/\/lyubomir-angelov.com\/blog\/#website","url":"https:\/\/lyubomir-angelov.com\/blog\/","name":"Lyubomir Angelov","description":"The life of a Manager","publisher":{"@id":"https:\/\/lyubomir-angelov.com\/blog\/#\/schema\/person\/5e091f5c2fa79f57d30d482a7ef8cd92"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/lyubomir-angelov.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/lyubomir-angelov.com\/blog\/#\/schema\/person\/5e091f5c2fa79f57d30d482a7ef8cd92","name":"Lyubomir","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/lyubomir-angelov.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/f6b8c15868355fa857fad18647aeadd07814e3d9baa72a1c92e718056684fec7?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f6b8c15868355fa857fad18647aeadd07814e3d9baa72a1c92e718056684fec7?s=96&d=mm&r=g","caption":"Lyubomir"},"logo":{"@id":"https:\/\/lyubomir-angelov.com\/blog\/#\/schema\/person\/image\/"},"sameAs":["https:\/\/twitter.com\/angelovcode"],"url":"https:\/\/lyubomir-angelov.com\/blog\/author\/superfly\/"}]}},"_links":{"self":[{"href":"https:\/\/lyubomir-angelov.com\/blog\/wp-json\/wp\/v2\/posts\/100","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lyubomir-angelov.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/lyubomir-angelov.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/lyubomir-angelov.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/lyubomir-angelov.com\/blog\/wp-json\/wp\/v2\/comments?post=100"}],"version-history":[{"count":8,"href":"https:\/\/lyubomir-angelov.com\/blog\/wp-json\/wp\/v2\/posts\/100\/revisions"}],"predecessor-version":[{"id":186,"href":"https:\/\/lyubomir-angelov.com\/blog\/wp-json\/wp\/v2\/posts\/100\/revisions\/186"}],"wp:attachment":[{"href":"https:\/\/lyubomir-angelov.com\/blog\/wp-json\/wp\/v2\/media?parent=100"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lyubomir-angelov.com\/blog\/wp-json\/wp\/v2\/categories?post=100"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lyubomir-angelov.com\/blog\/wp-json\/wp\/v2\/tags?post=100"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}