{"id":59,"date":"2012-08-19T11:23:00","date_gmt":"2012-08-19T11:23:00","guid":{"rendered":"\/colin\/morethanfour\/post\/Long-columns-wrapping-in-the-SQL-Result-Grid"},"modified":"2012-08-19T11:23:00","modified_gmt":"2012-08-19T11:23:00","slug":"long-columns-wrapping-in-the-sql-result-grid","status":"publish","type":"post","link":"https:\/\/spacefold.com\/colin\/morethanfour\/2012\/08\/19\/long-columns-wrapping-in-the-sql-result-grid\/","title":{"rendered":"Long columns wrapping in the SQL Result Grid"},"content":{"rendered":"<p>Have you ever experienced a moment when you find that an application you&#8217;ve used for years has a feature that, if only you&#8217;d known about it, would have saved you time over and over again? It&#8217;s a mixed feeling&#8230; one one hand, it&#8217;s &#8220;Yay, this software is awesome!&#8221; and the other it&#8217;s &#8220;Doh! I&#8217;m an idiot!&#8221;. <\/p>\n<p>Well, <a href=\"http:\/\/www.allroundautomations.com\/plsqldev.html\">PL\/SQL Developer<\/a> just handed me another of those moments. <\/p>\n<p>In the result grid of the SQL Query window, you can resize any row by grabbing the separator line in the margin and pulling down. I think I knew that&#8230; but what didn&#8217;t realize is that any column with a long string will then wrap into the extra space, like this:<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/www.spacefold.com\/colin\/morethanfour\/wp-content\/uploads\/2012%2f9%2fplsd_grid_row_expand.gif\" alt=\"\" \/><\/p>\n<p>I think that is pretty cool. And it&#8217;s been in the product since at least version 8 (which is what I&#8217;ve used for the last few years).<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Have you ever experienced a moment when you find that an application you&#8217;ve used for years has a feature that, if only you&#8217;d known about it, would have saved you time over and over again? It&#8217;s a mixed feeling&#8230; one one hand, it&#8217;s &#8220;Yay, this software is awesome!&#8221; and the other it&#8217;s &#8220;Doh! I&#8217;m an [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13],"tags":[],"class_list":["post-59","post","type-post","status-publish","format-standard","hentry","category-pl-sql-developer","post-preview"],"_links":{"self":[{"href":"https:\/\/spacefold.com\/colin\/morethanfour\/wp-json\/wp\/v2\/posts\/59","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/spacefold.com\/colin\/morethanfour\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/spacefold.com\/colin\/morethanfour\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/spacefold.com\/colin\/morethanfour\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/spacefold.com\/colin\/morethanfour\/wp-json\/wp\/v2\/comments?post=59"}],"version-history":[{"count":0,"href":"https:\/\/spacefold.com\/colin\/morethanfour\/wp-json\/wp\/v2\/posts\/59\/revisions"}],"wp:attachment":[{"href":"https:\/\/spacefold.com\/colin\/morethanfour\/wp-json\/wp\/v2\/media?parent=59"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/spacefold.com\/colin\/morethanfour\/wp-json\/wp\/v2\/categories?post=59"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/spacefold.com\/colin\/morethanfour\/wp-json\/wp\/v2\/tags?post=59"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}