{"id":1696,"date":"2014-05-14T16:02:30","date_gmt":"2014-05-14T14:02:30","guid":{"rendered":"http:\/\/www.oradba.ch\/?p=1696"},"modified":"2014-05-16T00:03:45","modified_gmt":"2014-05-15T22:03:45","slug":"trivadis-plsql-sql-codechecker","status":"publish","type":"post","link":"https:\/\/www.oradba.ch\/wordpress\/2014\/05\/trivadis-plsql-sql-codechecker\/","title":{"rendered":"Trivadis PL\/SQL &#038; SQL CodeChecker"},"content":{"rendered":"<p>A couple of days ago Trivadis released the <a href=\"http:\/\/www.salvis.com\/blog\/2014\/04\/30\/trivadis-plsql-sql-codechecker-for-sql-developer-released\/\">Trivadis PL\/SQL &#038; SQL CodeChecker (tvdcc)<\/a> as SQL Developer Extension. TVDCC does check the editor content for compliance violations of the <a href=\"http:\/\/www.trivadis.com\/uploads\/tx_cabagdownloadarea\/PLSQL_and_SQL_Coding_Guidelines_2_0_HiRes.pdf\">Trivadis PL\/SQL &#038;  SQL Coding Guidelines Version 2.0<\/a>.<\/p>\n<p>Quote from the blog post of my work colleague:<\/p>\n<blockquote><p>\nFurthermore McCabe\u2019s cyclomatic complexity, Halstead\u2019s volume, the maintainability index and some other software metrics are calculated for each PL\/SQL unit and aggregated on file level.<\/p>\n<p>The results are presented in an additional tabbed panel. One tab shows all guideline violations to quickly navigate to the corresponding code position, the other tab contains a full HTML report, which also may be opened in your external browser.\n<\/p><\/blockquote>\n<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/tvdcc_sqldev_report.png?resize=600%2C350&#038;ssl=1\" alt=\"Tvdcc sqldev report\" title=\"tvdcc_sqldev_report.png\" border=\"0\" width=\"600\" height=\"350\" \/><\/p>\n<p>It is a convenient tool, especially if you do not regularly developed PL \/ SQL code. <\/p>\n<h3>References<\/h3>\n<p>Additional information and links related to the Trivadis PL\/SQL &#038; SQL CodeChecker.<\/p>\n<ul>\n<li><a href=\"http:\/\/www.salvis.com\/blog\/2014\/04\/30\/trivadis-plsql-sql-codechecker-for-sql-developer-released\/\">Trivadis PL\/SQL &#038; SQL CodeChecker for SQL Developer Released<\/a><\/li>\n<li><a href=\"http:\/\/www.salvis.com\/blog\/downloads\/tvdcc-trivadis-plsql-sql-codechecker-for-sql-developer\/\">TVDCC for SQL Developer 0.7.5 Beta<\/a><\/li>\n<li><a href=\"http:\/\/www.salvis.com\/blog\/2013\/10\/20\/trivadis-plsql-sql-codechecker-released\/\">Trivadis PL\/SQL &#038; SQL CodeChecker Released<\/a><\/li>\n<li><a href=\"http:\/\/www.trivadis.com\/uploads\/tx_cabagdownloadarea\/PLSQL_and_SQL_Coding_Guidelines_2_0_HiRes.pdf\">Trivadis PL\/SQL &#038; SQL Coding Guidelines Version 2.0.<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>A couple of days ago Trivadis released the Trivadis PL\/SQL &#038; SQL CodeChecker (tvdcc) as SQL Developer Extension. TVDCC does check the editor content for compliance violations of the Trivadis PL\/SQL &#038; SQL Coding Guidelines Version 2.0. Quote from the blog post of my work colleague: Furthermore McCabe\u2019s cyclomatic complexity, Halstead\u2019s volume, the maintainability index [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"Trivadis PL\/SQL & SQL CodeChecker http:\/\/wp.me\/p1aErb-rm #trivadis #sqldeveloper","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[8,83,128,5,129],"tags":[131,130],"class_list":["post-1696","post","type-post","status-publish","format-standard","hentry","category-11gr2","category-12cr1","category-best-practice","category-oracle-database","category-sql-developer","tag-plsql","tag-trivadis"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p1aErb-rm","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":2273,"url":"https:\/\/www.oradba.ch\/wordpress\/2017\/04\/eu-gdpr-ms-sql-server-2016-and-oracle-security\/","url_meta":{"origin":1696,"position":0},"title":"EU GDPR, MS SQL Server 2016 and Oracle Security","author":"Stefan","date":"21. April 2017","format":false,"excerpt":"I've just updated the list of my public appearances and planned events. For once, no just Oracle Events :-) I'll speak about the new EU GDPR and its impact on databases in a Trivadis regional customer event together with my colleague Stephan Hurni. Beside this two events I'll hold a\u2026","rel":"","context":"In &quot;12cR2&quot;","block_context":{"text":"12cR2","link":"https:\/\/www.oradba.ch\/wordpress\/category\/oracle-database\/12cr2\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1924,"url":"https:\/\/www.oradba.ch\/wordpress\/2015\/01\/oracle-cpu-psu-pre-release-announcement-january-2015\/","url_meta":{"origin":1696,"position":1},"title":"Oracle CPU \/ PSU Pre-Release Announcement January 2015","author":"Stefan","date":"20. January 2015","format":false,"excerpt":"Oracle has published the Pre-Release Announcement for the first Critical Patch Update in 2015. This Critical Patch Update contains 167 new security vulnerability fixes across all Oracle products. It looks like that this CPU does contain a bunch of critical security fixes for Oracle databases. Actually there are 7 fixes\u2026","rel":"","context":"In &quot;11gR2&quot;","block_context":{"text":"11gR2","link":"https:\/\/www.oradba.ch\/wordpress\/category\/oracle-database\/11gr2\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2306,"url":"https:\/\/www.oradba.ch\/wordpress\/2017\/06\/gdpr-and-database-security-speeches\/","url_meta":{"origin":1696,"position":2},"title":"GDPR and Database Security Speeches","author":"Stefan","date":"16. June 2017","format":false,"excerpt":"The new EU GDPR and Database Security in general keeps me busy. I've updated the list of speeches and events for the next couple of month. It's an interesting mix between GDPR, Oracle Database Security and MS SQL Server 2016 security. Depending on the feedback of the Call For Papers\u2026","rel":"","context":"In &quot;Oracle Database&quot;","block_context":{"text":"Oracle Database","link":"https:\/\/www.oradba.ch\/wordpress\/category\/oracle-database\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1393,"url":"https:\/\/www.oradba.ch\/wordpress\/2013\/08\/ora-00600-kpdbmodadminpasswdinroot-not-cdb-when-changing-password-of-default-account\/","url_meta":{"origin":1696,"position":3},"title":"ORA-00600 [kpdbModAdminPasswdInRoot: not CDB] when changing password of default account","author":"Stefan","date":"26. August 2013","format":false,"excerpt":"During the test on Oracle Database 12c I run into an interesting error respectively Chris Antongini has made me aware of it. If you try to change the password of an Oracle default account on a none CDB with SQL*Plus [cci lang=\"bash\"]password[\/cci] you run into an ORA-00600 [kpdbModAdminPasswdInRoot: not CDB]\u2026","rel":"","context":"In &quot;12cR1&quot;","block_context":{"text":"12cR1","link":"https:\/\/www.oradba.ch\/wordpress\/category\/oracle-database\/12cr1\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3240,"url":"https:\/\/www.oradba.ch\/wordpress\/2019\/09\/audit-trail-cleanup-in-oracle-multitenant-environments\/","url_meta":{"origin":1696,"position":4},"title":"Audit Trail cleanup in Oracle Multitenant environments","author":"Stefan","date":"20. September 2019","format":false,"excerpt":"A crucial aspect of any database audit concept is the management and maintenance of audit trails. Depending on the defined audit policies and the database activity, an audit trail can grow relatively quickly. Oracle Multitenant environments increase the operational effort because the root container and each PDB uses their own\u2026","rel":"","context":"In &quot;12R2&quot;","block_context":{"text":"12R2","link":"https:\/\/www.oradba.ch\/wordpress\/category\/oracle-database\/12r2\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2053,"url":"https:\/\/www.oradba.ch\/wordpress\/2015\/10\/wallet_location-in-sqlnet-ora-for-container-databases\/","url_meta":{"origin":1696,"position":5},"title":"WALLET_LOCATION in sqlnet.ora for Container Databases","author":"Stefan","date":"31. October 2015","format":false,"excerpt":"Recently I've setup Oracle Enterprise User Security (EUS) with Oracle Unified Directory (OUD) on my favorite linux test system. Among regular 11.2.0.4 and 12.1.0.2 databases I do also have a 12.1.0.2 Container Database. EUS work like a charm on the regular databases but not on the PDB. [cc lang=\"sql\"] SQL>\u2026","rel":"","context":"In &quot;12cR1&quot;","block_context":{"text":"12cR1","link":"https:\/\/www.oradba.ch\/wordpress\/category\/oracle-database\/12cr1\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/posts\/1696","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/comments?post=1696"}],"version-history":[{"count":3,"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/posts\/1696\/revisions"}],"predecessor-version":[{"id":1707,"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/posts\/1696\/revisions\/1707"}],"wp:attachment":[{"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/media?parent=1696"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/categories?post=1696"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/tags?post=1696"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}