{"id":1527,"date":"2012-07-18T22:07:43","date_gmt":"2012-07-19T03:07:43","guid":{"rendered":"http:\/\/www.dpriver.com\/blog\/?p=1527"},"modified":"2012-07-18T22:07:43","modified_gmt":"2012-07-19T03:07:43","slug":"new-release-sql-pretty-printer-version-3-3-2","status":"publish","type":"post","link":"https:\/\/www.dpriver.com\/blog\/new-release-sql-pretty-printer-version-3-3-2\/","title":{"rendered":"NEW RELEASE: SQL PRETTY PRINTER VERSION 3.3.2"},"content":{"rendered":"<p>SQL Pretty Printer V3.3.2 desktop version is available on July 19, 2012.<\/p>\n<p>You can download the latest version here:<br \/>\nDesktop version: <a href=\"http:\/\/www.dpriver.com\/dl\/sqlpp_desktop_3_3_2.zip\" title=\"sql pretty printer desktop version download\">http:\/\/www.dpriver.com\/dl\/sqlpp_desktop_3_3_2.zip<\/a><\/p>\n<p>We have added one new format option gFmtOpt.TrueLeft, left align all keywords including AND\/OR and ON keyword in join clause. Here is the sql formatted when gFmtOpt.TrueLeft set to true.<\/p>\n<p>\n<img decoding=\"async\" src=\"http:\/\/www.dpriver.com\/images\/screenshots\/v332\/trueleft_sql.png\" alt=\"sql pretty printer format option: true left\" \/><\/p>\n<p>In order to make this format option works correctly, following options must be set correspondingly.<\/p>\n<p>\n<img decoding=\"async\" src=\"http:\/\/www.dpriver.com\/images\/screenshots\/v332\/trueleft_main.png\" alt=\"sql pretty printer format options: true left\" \/><\/p>\n<hr>\n<p>\n<img decoding=\"async\" src=\"http:\/\/www.dpriver.com\/images\/screenshots\/v332\/trueleft_other_options.png\" alt=\"sql pretty printer format options: true left\" \/><\/p>\n<p>Some other improvements in this release:<\/p>\n<ul class=\"Element146\">\n<li class=\"Element147\">[plsql] support label before function call statement<\/li>\n<li class=\"Element147\">[plsql] support create package body with empty statements inside.<\/li>\n<li class=\"Element147\">[MySQL] select statement in group_concat function was parsed<\/li>\n<li class=\"Element147\">[MySQL] able to format create view statement of MySQL<\/li>\n<li class=\"Element147\">[MySQL] add support for [DEFINER = { user | CURRENT_USER }] and [SQL SECURITY { DEFINER | INVOKER }] in create view statement.<\/li>\n<li class=\"Element147\">[MySQL] support multi-list of characteristic such as READS SQL DATA in create procedure statement<\/li>\n<li class=\"Element147\">[MySQL] add support for [DEFINER = { user | CURRENT_USER }]  in create procedure statement<\/li>\n<li class=\"Element147\">[MySQL] support into clause like: SELECT COUNT(*) FROM tmpT INTO variablename;<\/li>\n<li class=\"Element147\">[DB2]  fix a bug can&#8217;t process if statement correctly inside block.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>SQL Pretty Printer V3.3.2 desktop version is available on July 19, 2012. You can download the latest version here: Desktop version: http:\/\/www.dpriver.com\/dl\/sqlpp_desktop_3_3_2.zip We have added one new format option gFmtOpt.TrueLeft, left align all keywords including AND\/OR and ON keyword in join clause. Here is the sql formatted when gFmtOpt.TrueLeft set to true. In order to make this format option works correctly, following options must be set correspondingly. Some other improvements in this release: [plsql] support label before function call statement [plsql] support create package body with empty statements inside. [MySQL] select statement in group_concat function was parsed [MySQL] able to\u2026<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[13,24],"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>NEW RELEASE: SQL PRETTY PRINTER VERSION 3.3.2<\/title>\n<meta name=\"description\" content=\"NEW RELEASE: SQL PRETTY PRINTER VERSION 3.3.2\" \/>\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\/new-release-sql-pretty-printer-version-3-3-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"NEW RELEASE: SQL PRETTY PRINTER VERSION 3.3.2\" \/>\n<meta property=\"og:description\" content=\"NEW RELEASE: SQL PRETTY PRINTER VERSION 3.3.2\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dpriver.com\/blog\/new-release-sql-pretty-printer-version-3-3-2\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL and Data Blog\" \/>\n<meta property=\"article:published_time\" content=\"2012-07-19T03:07:43+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.dpriver.com\/images\/screenshots\/v332\/trueleft_sql.png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\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\/new-release-sql-pretty-printer-version-3-3-2\/\",\"url\":\"https:\/\/www.dpriver.com\/blog\/new-release-sql-pretty-printer-version-3-3-2\/\",\"name\":\"NEW RELEASE: SQL PRETTY PRINTER VERSION 3.3.2\",\"isPartOf\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/#website\"},\"datePublished\":\"2012-07-19T03:07:43+00:00\",\"dateModified\":\"2012-07-19T03:07:43+00:00\",\"description\":\"NEW RELEASE: SQL PRETTY PRINTER VERSION 3.3.2\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/new-release-sql-pretty-printer-version-3-3-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dpriver.com\/blog\/new-release-sql-pretty-printer-version-3-3-2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/new-release-sql-pretty-printer-version-3-3-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.dpriver.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"NEW RELEASE: SQL PRETTY PRINTER VERSION 3.3.2\"}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/new-release-sql-pretty-printer-version-3-3-2\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/new-release-sql-pretty-printer-version-3-3-2\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/fd33d9e572b65788a80dc4bac2b4e5a7\"},\"headline\":\"NEW RELEASE: SQL PRETTY PRINTER VERSION 3.3.2\",\"datePublished\":\"2012-07-19T03:07:43+00:00\",\"dateModified\":\"2012-07-19T03:07:43+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/new-release-sql-pretty-printer-version-3-3-2\/\"},\"wordCount\":186,\"publisher\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/#organization\"},\"articleSection\":[\"release\",\"sql pretty printer\"],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/fd33d9e572b65788a80dc4bac2b4e5a7\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/61d4e409068502b7e4960eb89efb79f8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/61d4e409068502b7e4960eb89efb79f8?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"url\":\"https:\/\/www.dpriver.com\/blog\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"NEW RELEASE: SQL PRETTY PRINTER VERSION 3.3.2","description":"NEW RELEASE: SQL PRETTY PRINTER VERSION 3.3.2","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\/new-release-sql-pretty-printer-version-3-3-2\/","og_locale":"en_US","og_type":"article","og_title":"NEW RELEASE: SQL PRETTY PRINTER VERSION 3.3.2","og_description":"NEW RELEASE: SQL PRETTY PRINTER VERSION 3.3.2","og_url":"https:\/\/www.dpriver.com\/blog\/new-release-sql-pretty-printer-version-3-3-2\/","og_site_name":"SQL and Data Blog","article_published_time":"2012-07-19T03:07:43+00:00","og_image":[{"url":"http:\/\/www.dpriver.com\/images\/screenshots\/v332\/trueleft_sql.png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","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\/new-release-sql-pretty-printer-version-3-3-2\/","url":"https:\/\/www.dpriver.com\/blog\/new-release-sql-pretty-printer-version-3-3-2\/","name":"NEW RELEASE: SQL PRETTY PRINTER VERSION 3.3.2","isPartOf":{"@id":"https:\/\/www.dpriver.com\/blog\/#website"},"datePublished":"2012-07-19T03:07:43+00:00","dateModified":"2012-07-19T03:07:43+00:00","description":"NEW RELEASE: SQL PRETTY PRINTER VERSION 3.3.2","breadcrumb":{"@id":"https:\/\/www.dpriver.com\/blog\/new-release-sql-pretty-printer-version-3-3-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dpriver.com\/blog\/new-release-sql-pretty-printer-version-3-3-2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dpriver.com\/blog\/new-release-sql-pretty-printer-version-3-3-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dpriver.com\/blog\/"},{"@type":"ListItem","position":2,"name":"NEW RELEASE: SQL PRETTY PRINTER VERSION 3.3.2"}]},{"@type":"Article","@id":"https:\/\/www.dpriver.com\/blog\/new-release-sql-pretty-printer-version-3-3-2\/#article","isPartOf":{"@id":"https:\/\/www.dpriver.com\/blog\/new-release-sql-pretty-printer-version-3-3-2\/"},"author":{"name":"admin","@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/fd33d9e572b65788a80dc4bac2b4e5a7"},"headline":"NEW RELEASE: SQL PRETTY PRINTER VERSION 3.3.2","datePublished":"2012-07-19T03:07:43+00:00","dateModified":"2012-07-19T03:07:43+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dpriver.com\/blog\/new-release-sql-pretty-printer-version-3-3-2\/"},"wordCount":186,"publisher":{"@id":"https:\/\/www.dpriver.com\/blog\/#organization"},"articleSection":["release","sql pretty printer"],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/fd33d9e572b65788a80dc4bac2b4e5a7","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/61d4e409068502b7e4960eb89efb79f8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/61d4e409068502b7e4960eb89efb79f8?s=96&d=mm&r=g","caption":"admin"},"url":"https:\/\/www.dpriver.com\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/posts\/1527"}],"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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/comments?post=1527"}],"version-history":[{"count":8,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/posts\/1527\/revisions"}],"predecessor-version":[{"id":1535,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/posts\/1527\/revisions\/1535"}],"wp:attachment":[{"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/media?parent=1527"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/categories?post=1527"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/tags?post=1527"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}