{"id":11536,"date":"2022-07-17T14:21:08","date_gmt":"2022-07-17T12:21:08","guid":{"rendered":"https:\/\/www.salvis.com\/blog\/?p=11536"},"modified":"2023-11-08T16:39:50","modified_gmt":"2023-11-08T15:39:50","slug":"plscope-utils-for-sql-developer-1-0-whats-new","status":"publish","type":"post","link":"https:\/\/www.salvis.com\/blog\/2022\/07\/17\/plscope-utils-for-sql-developer-1-0-whats-new\/","title":{"rendered":"plscope-utils for SQL Developer 1.0 &#8211; What&#8217;s New?"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Introduction<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">PL\/Scope is an SDK for source code analysis. It is available since Oracle Database 11g Release 1 and has been significantly improved in 12c Release 2.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">plscope-utils for SQL Developer is a SQL Developer extension that simplifies the compilation with PL\/Scope, visualizes PL\/Scope information under a <code>PL\/Scope<\/code> node in the Connections window and provides various source code analysis reports.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Follow <a href=\"https:\/\/github.com\/PhilippSalvisberg\/plscope-utils\/tree\/main\/sqldev#user-content-installation\">these instructions<\/a> for a fresh install or an update to the latest version of plscope-utils for SQL Developer.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Updated Tree Structure<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The level for grouping primary and secondary object types was removed. This makes the the tree simpler. All object types can now be filtered. This is especially helpful for schemas with many objects. And there is an additional node for <code>Sequences<\/code>.<\/p>\n\n\n\n<figure class=\"wp-block-image is-resized\"><a href=\"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2022\/07\/plscope_node.png\"><img loading=\"lazy\" decoding=\"async\" width=\"536\" height=\"688\" src=\"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2022\/07\/plscope_node.png\" alt=\"PL\/Scope node in SQL Developer's Connection window (plscope-utils)\" class=\"wp-image-11540\" style=\"width:268px\" srcset=\"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2022\/07\/plscope_node.png 536w, https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2022\/07\/plscope_node-234x300.png 234w, https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2022\/07\/plscope_node-114x146.png 114w, https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2022\/07\/plscope_node-39x50.png 39w, https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2022\/07\/plscope_node-58x75.png 58w, https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2022\/07\/plscope_node-1x1.png 1w\" sizes=\"auto, (max-width:767px) 480px, 536px\" \/><\/a><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">No more ORA-01436: CONNECT BY loop in user data<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Many queries are based on recursive structures. In some data constellations, an ORA-1436 error caused no result to be returned. The reasons for this were manifold. Due to wrongly fixed hierarchies or due to dependency loops in the Oracle data dictionary. However, incomplete hierarchies are now fixed without causing a loop and all hierarchical queries use the <a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/sqlrf\/SELECT.html#GUID-CFA006CA-6FF1-4972-821E-6996142A51C6__GUID-6EE9767D-C75F-4AD4-A949-F19F62434C51\">cycle_clause<\/a> which detects loops, avoids such runtime errors and ensures a reasonable result even with loops in the underlying data.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Concise Representation of Identifiers<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Romain Vassallo contributed a <a href=\"https:\/\/github.com\/PhilippSalvisberg\/plscope-utils\/pull\/38\">pull request<\/a> for the <code>plscope_identifiers<\/code> view. He added a column <code>name_usage<\/code> to combine <code>name<\/code>, <code>type<\/code>, <code>usage<\/code> and <code>sql_id<\/code> in a single column with a left indent of two characters per level.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The <code>Identifiers<\/code> tab includes now a column <code>Name (Type, Usage)<\/code> with this nifty logic.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2022\/07\/identifiers_editor_plscope_utils-1.png\"><img loading=\"lazy\" decoding=\"async\" width=\"3456\" height=\"2154\" src=\"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2022\/07\/identifiers_editor_plscope_utils-1.png\" alt=\"PL\/Scope identifiers tab in SQL Developer (plscope-utils)\" class=\"wp-image-11546\" srcset=\"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2022\/07\/identifiers_editor_plscope_utils-1.png 3456w, https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2022\/07\/identifiers_editor_plscope_utils-1-300x187.png 300w, https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2022\/07\/identifiers_editor_plscope_utils-1-1024x638.png 1024w, https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2022\/07\/identifiers_editor_plscope_utils-1-768x479.png 768w, https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2022\/07\/identifiers_editor_plscope_utils-1-1536x957.png 1536w, https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2022\/07\/identifiers_editor_plscope_utils-1-2048x1276.png 2048w, https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2022\/07\/identifiers_editor_plscope_utils-1-234x146.png 234w, https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2022\/07\/identifiers_editor_plscope_utils-1-50x31.png 50w, https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2022\/07\/identifiers_editor_plscope_utils-1-120x75.png 120w, https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2022\/07\/identifiers_editor_plscope_utils-1-1x1.png 1w\" sizes=\"auto, (max-width:767px) 480px, (max-width:3456px) 100vw, 3456px\" \/><\/a><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">That&#8217;s all?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Yes, regarding plscope-utils for SQL Developer. However, there are optional <a href=\"https:\/\/github.com\/PhilippSalvisberg\/plscope-utils\/blob\/main\/database\/README.md\">PL\/SQL packages and views<\/a> for static code analysis based on PL\/Scope. Optional means, the SQL Developer extension does not need them. But if you have to analyze code in your Oracle database they can be a good starting point for your work.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Related Information<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">If you are interested in PL\/Scope, the following links may be of interest:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/github.com\/PhilippSalvisberg\/plscope-utils\/releases\">plscope-utils releases<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/github.com\/PhilippSalvisberg\/plscope-utils\">plscope-utils on Github (Core Database Objects and SQL Developer Extension)<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/adfns\/plscope.html#GUID-24109CB5-7BB9-48B2-AD7A-39458AA13C0C\">Oracle Database Development Guide 19c &#8211; Using PL\/Scope<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.salvis.com\/blog\/2017\/10\/15\/entity-relationship-model-for-plscope\/\">Entity Relationship Model for PL\/Scope<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.salvis.com\/blog\/2017\/10\/14\/limitations-of-plscope-and-how-to-deal-with-them\/\">Limitations of PL\/Scope and How to Deal with Them<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Introduction PL\/Scope is an SDK for source code analysis. It is available since Oracle Database 11g Release 1 and has been significantly improved in 12c Release 2. plscope-utils for SQL Developer is a SQL Developer extension that simplifies the compilation with PL\/Scope, visualizes PL\/Scope information under a PL\/Scope node in the Connections<span class=\"excerpt-hellip\"> [\u2026]<\/span><\/p>\n","protected":false},"author":1,"featured_media":11552,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[86,97,13,85,87],"class_list":["post-11536","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-code-analysis","tag-plscope","tag-plsql","tag-sql","tag-sql-developer"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>plscope-utils for SQL Developer 1.0 - What&#039;s New? - Philipp Salvisberg&#039;s Blog<\/title>\n<meta name=\"description\" content=\"plscope-utils for SQL Developer simplifies the use of PL\/Scope in the IDE. This blog post shows the new features in version 1.0.\" \/>\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.salvis.com\/blog\/2022\/07\/17\/plscope-utils-for-sql-developer-1-0-whats-new\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"plscope-utils for SQL Developer 1.0 - What&#039;s New? - Philipp Salvisberg&#039;s Blog\" \/>\n<meta property=\"og:description\" content=\"plscope-utils for SQL Developer simplifies the use of PL\/Scope in the IDE. This blog post shows the new features in version 1.0.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.salvis.com\/blog\/2022\/07\/17\/plscope-utils-for-sql-developer-1-0-whats-new\/\" \/>\n<meta property=\"og:site_name\" content=\"Philipp Salvisberg&#039;s Blog\" \/>\n<meta property=\"article:published_time\" content=\"2022-07-17T12:21:08+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-08T15:39:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2022\/07\/plscope-utils-feature.png\" \/>\n\t<meta property=\"og:image:width\" content=\"536\" \/>\n\t<meta property=\"og:image:height\" content=\"402\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Philipp Salvisberg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@phsalvisberg\" \/>\n<meta name=\"twitter:site\" content=\"@phsalvisberg\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Philipp Salvisberg\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2022\\\/07\\\/17\\\/plscope-utils-for-sql-developer-1-0-whats-new\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2022\\\/07\\\/17\\\/plscope-utils-for-sql-developer-1-0-whats-new\\\/\"},\"author\":{\"name\":\"Philipp Salvisberg\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/#\\\/schema\\\/person\\\/34352245c48678b1a5a05d4bc1339515\"},\"headline\":\"plscope-utils for SQL Developer 1.0 &#8211; What&#8217;s New?\",\"datePublished\":\"2022-07-17T12:21:08+00:00\",\"dateModified\":\"2023-11-08T15:39:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2022\\\/07\\\/17\\\/plscope-utils-for-sql-developer-1-0-whats-new\\\/\"},\"wordCount\":370,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/#\\\/schema\\\/person\\\/34352245c48678b1a5a05d4bc1339515\"},\"image\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2022\\\/07\\\/17\\\/plscope-utils-for-sql-developer-1-0-whats-new\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/07\\\/plscope-utils-feature.png\",\"keywords\":[\"Code Analysis\",\"PL\\\/Scope\",\"PL\\\/SQL\",\"SQL\",\"SQL Developer\"],\"articleSection\":[\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2022\\\/07\\\/17\\\/plscope-utils-for-sql-developer-1-0-whats-new\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2022\\\/07\\\/17\\\/plscope-utils-for-sql-developer-1-0-whats-new\\\/\",\"url\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2022\\\/07\\\/17\\\/plscope-utils-for-sql-developer-1-0-whats-new\\\/\",\"name\":\"plscope-utils for SQL Developer 1.0 - What's New? - Philipp Salvisberg&#039;s Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2022\\\/07\\\/17\\\/plscope-utils-for-sql-developer-1-0-whats-new\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2022\\\/07\\\/17\\\/plscope-utils-for-sql-developer-1-0-whats-new\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/07\\\/plscope-utils-feature.png\",\"datePublished\":\"2022-07-17T12:21:08+00:00\",\"dateModified\":\"2023-11-08T15:39:50+00:00\",\"description\":\"plscope-utils for SQL Developer simplifies the use of PL\\\/Scope in the IDE. This blog post shows the new features in version 1.0.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2022\\\/07\\\/17\\\/plscope-utils-for-sql-developer-1-0-whats-new\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2022\\\/07\\\/17\\\/plscope-utils-for-sql-developer-1-0-whats-new\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2022\\\/07\\\/17\\\/plscope-utils-for-sql-developer-1-0-whats-new\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/07\\\/plscope-utils-feature.png\",\"contentUrl\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/07\\\/plscope-utils-feature.png\",\"width\":536,\"height\":402},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2022\\\/07\\\/17\\\/plscope-utils-for-sql-developer-1-0-whats-new\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"plscope-utils for SQL Developer 1.0 &#8211; What&#8217;s New?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/\",\"name\":\"Philipp Salvisberg&#039;s Blog\",\"description\":\"Database-centric development\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/#\\\/schema\\\/person\\\/34352245c48678b1a5a05d4bc1339515\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/#\\\/schema\\\/person\\\/34352245c48678b1a5a05d4bc1339515\",\"name\":\"Philipp Salvisberg\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2010\\\/11\\\/phs_trivadis4.jpg\",\"url\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2010\\\/11\\\/phs_trivadis4.jpg\",\"contentUrl\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2010\\\/11\\\/phs_trivadis4.jpg\",\"width\":400,\"height\":400,\"caption\":\"Philipp Salvisberg\"},\"logo\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2010\\\/11\\\/phs_trivadis4.jpg\"},\"sameAs\":[\"http:\\\/\\\/www.salvis.com\\\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"plscope-utils for SQL Developer 1.0 - What's New? - Philipp Salvisberg&#039;s Blog","description":"plscope-utils for SQL Developer simplifies the use of PL\/Scope in the IDE. This blog post shows the new features in version 1.0.","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.salvis.com\/blog\/2022\/07\/17\/plscope-utils-for-sql-developer-1-0-whats-new\/","og_locale":"en_US","og_type":"article","og_title":"plscope-utils for SQL Developer 1.0 - What's New? - Philipp Salvisberg&#039;s Blog","og_description":"plscope-utils for SQL Developer simplifies the use of PL\/Scope in the IDE. This blog post shows the new features in version 1.0.","og_url":"https:\/\/www.salvis.com\/blog\/2022\/07\/17\/plscope-utils-for-sql-developer-1-0-whats-new\/","og_site_name":"Philipp Salvisberg&#039;s Blog","article_published_time":"2022-07-17T12:21:08+00:00","article_modified_time":"2023-11-08T15:39:50+00:00","og_image":[{"width":536,"height":402,"url":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2022\/07\/plscope-utils-feature.png","type":"image\/png"}],"author":"Philipp Salvisberg","twitter_card":"summary_large_image","twitter_creator":"@phsalvisberg","twitter_site":"@phsalvisberg","twitter_misc":{"Written by":"Philipp Salvisberg","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.salvis.com\/blog\/2022\/07\/17\/plscope-utils-for-sql-developer-1-0-whats-new\/#article","isPartOf":{"@id":"https:\/\/www.salvis.com\/blog\/2022\/07\/17\/plscope-utils-for-sql-developer-1-0-whats-new\/"},"author":{"name":"Philipp Salvisberg","@id":"https:\/\/www.salvis.com\/blog\/#\/schema\/person\/34352245c48678b1a5a05d4bc1339515"},"headline":"plscope-utils for SQL Developer 1.0 &#8211; What&#8217;s New?","datePublished":"2022-07-17T12:21:08+00:00","dateModified":"2023-11-08T15:39:50+00:00","mainEntityOfPage":{"@id":"https:\/\/www.salvis.com\/blog\/2022\/07\/17\/plscope-utils-for-sql-developer-1-0-whats-new\/"},"wordCount":370,"commentCount":0,"publisher":{"@id":"https:\/\/www.salvis.com\/blog\/#\/schema\/person\/34352245c48678b1a5a05d4bc1339515"},"image":{"@id":"https:\/\/www.salvis.com\/blog\/2022\/07\/17\/plscope-utils-for-sql-developer-1-0-whats-new\/#primaryimage"},"thumbnailUrl":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2022\/07\/plscope-utils-feature.png","keywords":["Code Analysis","PL\/Scope","PL\/SQL","SQL","SQL Developer"],"articleSection":["Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.salvis.com\/blog\/2022\/07\/17\/plscope-utils-for-sql-developer-1-0-whats-new\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.salvis.com\/blog\/2022\/07\/17\/plscope-utils-for-sql-developer-1-0-whats-new\/","url":"https:\/\/www.salvis.com\/blog\/2022\/07\/17\/plscope-utils-for-sql-developer-1-0-whats-new\/","name":"plscope-utils for SQL Developer 1.0 - What's New? - Philipp Salvisberg&#039;s Blog","isPartOf":{"@id":"https:\/\/www.salvis.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.salvis.com\/blog\/2022\/07\/17\/plscope-utils-for-sql-developer-1-0-whats-new\/#primaryimage"},"image":{"@id":"https:\/\/www.salvis.com\/blog\/2022\/07\/17\/plscope-utils-for-sql-developer-1-0-whats-new\/#primaryimage"},"thumbnailUrl":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2022\/07\/plscope-utils-feature.png","datePublished":"2022-07-17T12:21:08+00:00","dateModified":"2023-11-08T15:39:50+00:00","description":"plscope-utils for SQL Developer simplifies the use of PL\/Scope in the IDE. This blog post shows the new features in version 1.0.","breadcrumb":{"@id":"https:\/\/www.salvis.com\/blog\/2022\/07\/17\/plscope-utils-for-sql-developer-1-0-whats-new\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.salvis.com\/blog\/2022\/07\/17\/plscope-utils-for-sql-developer-1-0-whats-new\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.salvis.com\/blog\/2022\/07\/17\/plscope-utils-for-sql-developer-1-0-whats-new\/#primaryimage","url":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2022\/07\/plscope-utils-feature.png","contentUrl":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2022\/07\/plscope-utils-feature.png","width":536,"height":402},{"@type":"BreadcrumbList","@id":"https:\/\/www.salvis.com\/blog\/2022\/07\/17\/plscope-utils-for-sql-developer-1-0-whats-new\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.salvis.com\/blog\/"},{"@type":"ListItem","position":2,"name":"plscope-utils for SQL Developer 1.0 &#8211; What&#8217;s New?"}]},{"@type":"WebSite","@id":"https:\/\/www.salvis.com\/blog\/#website","url":"https:\/\/www.salvis.com\/blog\/","name":"Philipp Salvisberg&#039;s Blog","description":"Database-centric development","publisher":{"@id":"https:\/\/www.salvis.com\/blog\/#\/schema\/person\/34352245c48678b1a5a05d4bc1339515"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.salvis.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.salvis.com\/blog\/#\/schema\/person\/34352245c48678b1a5a05d4bc1339515","name":"Philipp Salvisberg","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2010\/11\/phs_trivadis4.jpg","url":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2010\/11\/phs_trivadis4.jpg","contentUrl":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2010\/11\/phs_trivadis4.jpg","width":400,"height":400,"caption":"Philipp Salvisberg"},"logo":{"@id":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2010\/11\/phs_trivadis4.jpg"},"sameAs":["http:\/\/www.salvis.com\/"]}]}},"_links":{"self":[{"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/posts\/11536","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/comments?post=11536"}],"version-history":[{"count":17,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/posts\/11536\/revisions"}],"predecessor-version":[{"id":12718,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/posts\/11536\/revisions\/12718"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/media\/11552"}],"wp:attachment":[{"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/media?parent=11536"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/categories?post=11536"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/tags?post=11536"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}