{"id":216,"date":"2010-07-15T04:07:00","date_gmt":"2010-07-15T09:07:00","guid":{"rendered":"http:\/\/www.dpriver.com\/blog\/2010\/07\/15\/general-sql-parser-java-v0-5-release\/"},"modified":"2011-09-26T21:39:44","modified_gmt":"2011-09-27T02:39:44","slug":"general-sql-parser-java-v0-5-release","status":"publish","type":"post","link":"https:\/\/www.dpriver.com\/blog\/2010\/07\/general-sql-parser-java-v0-5-release\/","title":{"rendered":"General SQL Parser Java v0.5 release"},"content":{"rendered":"<p>There are lots of improvements since V0.4,&nbsp;below are some of&nbsp;the most important improvements:<\/p>\n<ul>\n<li>Oracle SQL and PLSQL query parse tree structure was fully accessible. <\/li>\n<li>toString() of all parse tree node classes was supported, so you can get text of parse tree node.<\/li>\n<li>All classes are documented.<\/li>\n<li>Add an XML demo to illustrate how to visit query parse tree node, and generate XML output of SQL statement.<\/li>\n<\/ul>\n<p>You can download General SQL Parser Java version here:<br \/><a title=\"General SQL Parser Java version\" href=\"http:\/\/www.sqlparser.com\/download.php\">http:\/\/www.sqlparser.com\/download.php<\/a><\/p>\n<p>If you have any questions or comments about this SQL Parser, feel free to contact me:&nbsp; info@sqlparser.com<\/p>\n","protected":false},"excerpt":{"rendered":"<p>There are lots of improvements since V0.4,&nbsp;below are some of&nbsp;the most important improvements: Oracle SQL and PLSQL query parse tree structure was fully accessible. toString() of all parse tree node classes was supported, so you can get text of parse tree node. All classes are documented. Add an XML demo to illustrate how to visit query parse tree node, and generate XML output of SQL statement. You can download General SQL Parser Java version here:http:\/\/www.sqlparser.com\/download.php If you have any questions or comments about this SQL Parser, feel free to contact me:&nbsp; info@sqlparser.com<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[14,15],"tags":[],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":5}},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>General SQL Parser Java v0.5 release<\/title>\n<meta name=\"description\" content=\"General SQL Parser Java v0.5 release\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dpriver.com\/blog\/2010\/07\/general-sql-parser-java-v0-5-release\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"General SQL Parser Java v0.5 release\" \/>\n<meta property=\"og:description\" content=\"General SQL Parser Java v0.5 release\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dpriver.com\/blog\/2010\/07\/general-sql-parser-java-v0-5-release\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL and Data Blog\" \/>\n<meta property=\"article:published_time\" content=\"2010-07-15T09:07:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2011-09-27T02:39:44+00:00\" \/>\n<meta name=\"author\" content=\"James\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"James\" \/>\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\":\"Organization\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#organization\",\"name\":\"SQL and Data Blog\",\"url\":\"https:\/\/www.dpriver.com\/blog\/\",\"sameAs\":[],\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/07\/sqlpp-character.png\",\"contentUrl\":\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/07\/sqlpp-character.png\",\"width\":251,\"height\":72,\"caption\":\"SQL and Data Blog\"},\"image\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#website\",\"url\":\"https:\/\/www.dpriver.com\/blog\/\",\"name\":\"SQL and Data Blog\",\"description\":\"SQL related blog for database professional\",\"publisher\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dpriver.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/2010\/07\/general-sql-parser-java-v0-5-release\/\",\"url\":\"https:\/\/www.dpriver.com\/blog\/2010\/07\/general-sql-parser-java-v0-5-release\/\",\"name\":\"General SQL Parser Java v0.5 release\",\"isPartOf\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/#website\"},\"datePublished\":\"2010-07-15T09:07:00+00:00\",\"dateModified\":\"2011-09-27T02:39:44+00:00\",\"description\":\"General SQL Parser Java v0.5 release\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/2010\/07\/general-sql-parser-java-v0-5-release\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dpriver.com\/blog\/2010\/07\/general-sql-parser-java-v0-5-release\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/2010\/07\/general-sql-parser-java-v0-5-release\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.dpriver.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"General SQL Parser Java v0.5 release\"}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/2010\/07\/general-sql-parser-java-v0-5-release\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/2010\/07\/general-sql-parser-java-v0-5-release\/\"},\"author\":{\"name\":\"James\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/7bbdbb6e79c5dd9747d08c59d5992b04\"},\"headline\":\"General SQL Parser Java v0.5 release\",\"datePublished\":\"2010-07-15T09:07:00+00:00\",\"dateModified\":\"2011-09-27T02:39:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/2010\/07\/general-sql-parser-java-v0-5-release\/\"},\"wordCount\":111,\"publisher\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/#organization\"},\"articleSection\":[\"gsp\",\"release\"],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/7bbdbb6e79c5dd9747d08c59d5992b04\",\"name\":\"James\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/eeddf4ca7bdafa37ab025068efdc7302?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/eeddf4ca7bdafa37ab025068efdc7302?s=96&d=mm&r=g\",\"caption\":\"James\"},\"sameAs\":[\"http:\/\/www.dpriver.com\"],\"url\":\"https:\/\/www.dpriver.com\/blog\/author\/james\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"General SQL Parser Java v0.5 release","description":"General SQL Parser Java v0.5 release","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:\/\/www.dpriver.com\/blog\/2010\/07\/general-sql-parser-java-v0-5-release\/","og_locale":"en_US","og_type":"article","og_title":"General SQL Parser Java v0.5 release","og_description":"General SQL Parser Java v0.5 release","og_url":"https:\/\/www.dpriver.com\/blog\/2010\/07\/general-sql-parser-java-v0-5-release\/","og_site_name":"SQL and Data Blog","article_published_time":"2010-07-15T09:07:00+00:00","article_modified_time":"2011-09-27T02:39:44+00:00","author":"James","twitter_card":"summary_large_image","twitter_misc":{"Written by":"James","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Organization","@id":"https:\/\/www.dpriver.com\/blog\/#organization","name":"SQL and Data Blog","url":"https:\/\/www.dpriver.com\/blog\/","sameAs":[],"logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/07\/sqlpp-character.png","contentUrl":"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/07\/sqlpp-character.png","width":251,"height":72,"caption":"SQL and Data Blog"},"image":{"@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"WebSite","@id":"https:\/\/www.dpriver.com\/blog\/#website","url":"https:\/\/www.dpriver.com\/blog\/","name":"SQL and Data Blog","description":"SQL related blog for database professional","publisher":{"@id":"https:\/\/www.dpriver.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dpriver.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.dpriver.com\/blog\/2010\/07\/general-sql-parser-java-v0-5-release\/","url":"https:\/\/www.dpriver.com\/blog\/2010\/07\/general-sql-parser-java-v0-5-release\/","name":"General SQL Parser Java v0.5 release","isPartOf":{"@id":"https:\/\/www.dpriver.com\/blog\/#website"},"datePublished":"2010-07-15T09:07:00+00:00","dateModified":"2011-09-27T02:39:44+00:00","description":"General SQL Parser Java v0.5 release","breadcrumb":{"@id":"https:\/\/www.dpriver.com\/blog\/2010\/07\/general-sql-parser-java-v0-5-release\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dpriver.com\/blog\/2010\/07\/general-sql-parser-java-v0-5-release\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dpriver.com\/blog\/2010\/07\/general-sql-parser-java-v0-5-release\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dpriver.com\/blog\/"},{"@type":"ListItem","position":2,"name":"General SQL Parser Java v0.5 release"}]},{"@type":"Article","@id":"https:\/\/www.dpriver.com\/blog\/2010\/07\/general-sql-parser-java-v0-5-release\/#article","isPartOf":{"@id":"https:\/\/www.dpriver.com\/blog\/2010\/07\/general-sql-parser-java-v0-5-release\/"},"author":{"name":"James","@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/7bbdbb6e79c5dd9747d08c59d5992b04"},"headline":"General SQL Parser Java v0.5 release","datePublished":"2010-07-15T09:07:00+00:00","dateModified":"2011-09-27T02:39:44+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dpriver.com\/blog\/2010\/07\/general-sql-parser-java-v0-5-release\/"},"wordCount":111,"publisher":{"@id":"https:\/\/www.dpriver.com\/blog\/#organization"},"articleSection":["gsp","release"],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/7bbdbb6e79c5dd9747d08c59d5992b04","name":"James","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/eeddf4ca7bdafa37ab025068efdc7302?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/eeddf4ca7bdafa37ab025068efdc7302?s=96&d=mm&r=g","caption":"James"},"sameAs":["http:\/\/www.dpriver.com"],"url":"https:\/\/www.dpriver.com\/blog\/author\/james\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/posts\/216"}],"collection":[{"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/comments?post=216"}],"version-history":[{"count":3,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/posts\/216\/revisions"}],"predecessor-version":[{"id":1004,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/posts\/216\/revisions\/1004"}],"wp:attachment":[{"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/media?parent=216"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/categories?post=216"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/tags?post=216"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}