{"id":277,"date":"2008-10-12T10:21:52","date_gmt":"2008-10-12T09:21:52","guid":{"rendered":"http:\/\/bar-solutions.com\/wordpress\/?p=277"},"modified":"2008-10-12T10:21:52","modified_gmt":"2008-10-12T09:21:52","slug":"new-plsql-developer-plugins","status":"publish","type":"post","link":"https:\/\/blog.bar-solutions.com\/?p=277","title":{"rendered":"New PL\/SQL Developer plugins"},"content":{"rendered":"

The other day we had a presentation on PL\/SQL Developer<\/a> at AMIS<\/a>. Theo told a lot about the tool itself and he showed one of my newest plug-ins: Scrapbook. This is a plug in to make sort of a scrap of the current results of the SQL query you just executed.<\/p>\n

<\/p>\n

You could for instance use this to eye-ball the changes that occur in the database when you issue an Insert\/Update\/Delete statement. When you run your statement again, your old results will be overwritten. Using scrapbook<\/a> you can make a copy of the data so you can keep it, while rerunning your statement. This could help when checking whether a statement does what it is supposed to. Of course you can \u2018easily\u2019 copy the results to Excel or some other tool and use that to compare the results, but for quick and easy access it\u2019s probably better to have it in the current application.<\/p>\n

\"Select<\/a>select * from emp (before delete from emp where deptno = 20)<\/p>\n

\"Scrapbook\"<\/a> Results on scrapbook<\/p>\n

\"Select<\/a>select * from emp (after delete from emp where deptno = 20)<\/p>\n

 <\/p>\n

\"Multiple<\/a>\"Multiple<\/a>Then there was an issue about executing  multiple statements. When you have multiple statements in a single SQL window, and you execute it then all results will be displayed in a separate tabsheet.<\/p>\n

  <\/p>\n

 <\/p>\n

\"Single<\/a>\"Errormessage\"<\/a>You can run a single query by selecting this query and execute this window. But if you fail to select a complete query then you will get an error telling you that an invalid SQL statement has been issued to the database.<\/p>\n

<\/a><\/p>\n

\"Single<\/a>Alex asked if it was at all possible to run the current statement, by using a certain hotkey. Standard, this is unfortunately not possible. By using the execute current statement<\/a> plug-in you can execute the statement under the cursor, regardless of what you have selected in the window. The plug-in selects the current statement, runs it and returns control to the user.<\/p>\n

<\/a><\/p>\n

It takes some time to develop such a plug-in and it especially takes some time to figure out how to resolve the question, but that makes it fun to develop such a plug-in.<\/p>\n

<\/a><\/p>\n<\/p>\n<\/p>\n<\/p>\n<\/p>\n<\/p>\n

 <\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

The other day we had a presentation on PL\/SQL Developer at AMIS. Theo told a lot about the tool itself and he showed one of my newest plug-ins: Scrapbook. This is a plug in to make sort of a scrap of the current results of the SQL query you just executed.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,5,4],"tags":[],"class_list":["post-277","post","type-post","status-publish","format-standard","hentry","category-oracle","category-plsql","category-tools"],"_links":{"self":[{"href":"https:\/\/blog.bar-solutions.com\/index.php?rest_route=\/wp\/v2\/posts\/277","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.bar-solutions.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.bar-solutions.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.bar-solutions.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.bar-solutions.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=277"}],"version-history":[{"count":0,"href":"https:\/\/blog.bar-solutions.com\/index.php?rest_route=\/wp\/v2\/posts\/277\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.bar-solutions.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=277"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.bar-solutions.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=277"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.bar-solutions.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=277"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}