tag:blogger.com,1999:blog-7849367040589270673.post8007785541619548359..comments2024-03-21T22:50:39.997-07:00Comments on Obsessed with Oracle PL/SQL: Lint Checkers for PL/SQLSteven Feuersteinhttp://www.blogger.com/profile/18405765731886460622noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-7849367040589270673.post-82806848894841849092018-07-29T21:36:08.380-07:002018-07-29T21:36:08.380-07:00Hi Steve, sadly this must happen all the time, but...Hi Steve, sadly this must happen all the time, but someone called Priyaraj Thirukonda has ripped off your answer (and two replies), and posted it as their own work, at https://www.quora.com/Are-there-any-tools-available-to-check-coding-standards-in-PL-SQLChris Lewisnoreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-66737746350472296242018-05-27T00:30:32.387-07:002018-05-27T00:30:32.387-07:00Hi Steven,
Many thanks for sharing, I am trying t...Hi Steven,<br /><br />Many thanks for sharing, I am trying to explore SonarQube to analyze PL/SQL code but it is available only for eclipse.<br />Please help me out if you know any way to integrate with PL/SQL Developer or SQL Developer.<br /><br />Thanks,<br />MukeshMukesh Kumarhttps://www.blogger.com/profile/06590946151346751463noreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-17875381256070514842017-07-30T05:54:10.238-07:002017-07-30T05:54:10.238-07:00Nice post... I am using open source code review to...Nice post... I am using open source code review tools and this tool is beneficial to all developers, managers and architects. Thanks for sharingOpen source code review toolshttps://www.checkmarx.com/2014/11/13/the-ultimate-list-of-open-source-static-code-analysis-security-tools/noreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-57495406604361824172016-05-13T08:34:09.752-07:002016-05-13T08:34:09.752-07:00Ambuj, great idea, but no I do not know of a tool ...Ambuj, great idea, but no I do not know of a tool that can do that...though I am pretty sure that with Toad Code Analysis you can write your own rules, maybe you can do more now, I am not sure. Maybe others know more than me.Steven Feuersteinhttps://www.blogger.com/profile/18405765731886460622noreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-32733491247520668212016-05-13T02:58:17.419-07:002016-05-13T02:58:17.419-07:00Hi Steve,
My Organization is looking for a tool w...Hi Steve,<br /><br />My Organization is looking for a tool which can review the PL/SQL code based on our custom rules. Our requirement is that the tool can look into the delta piece of code which is added or modified and based on our rules it should give the report so that the developer can look for any issue and fix the same.<br /><br />Presently we are using CLear SQL tool but that does not suffice our requirement as it does not look into the delta piece o the code.<br /><br />Do you have any tools which can match our requirement or suggest any?.<br /><br />Reg,<br />Ambujambujhttps://www.blogger.com/profile/15358109597381382163noreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-27163362657703926442016-03-06T02:18:51.126-08:002016-03-06T02:18:51.126-08:00Hi Steve,
many thanks for this discussion, it'...Hi Steve,<br />many thanks for this discussion, it's very important.<br /><br />I have been working with PL/SQL Developer from Allround Automation since 10 years and I am very happy with it!<br /><br />The TVDCC from Trivadis is a very good concept, I like the PL/SQL Code Guidlines from Trivadis and I would like to try it in the next time.<br /><br />SonarQube has good PL/SQL rule definitions..<br /><br />Another good PL/SQL scanner is: http://www.conquestsoftwaresolutions.com/page/clearsql_pr_description<br /><br />Best RegardsFriedhold Matzhttps://www.blogger.com/profile/10340577232633666723noreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-22220164979074641832016-01-18T06:23:17.028-08:002016-01-18T06:23:17.028-08:00See PMD for PL/SQL
https://pmd.github.io/pmd-5.4.1...See PMD for PL/SQL<br />https://pmd.github.io/pmd-5.4.1/pmd-plsql/rules/index.html<br /><br />Kind RegardsTorsten Kleiberhttps://www.blogger.com/profile/16343344961106562369noreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-66083681318631231922015-04-08T05:53:57.535-07:002015-04-08T05:53:57.535-07:00We use SonarQube (http://www.sonarqube.org/) as co...We use SonarQube (http://www.sonarqube.org/) as code quality checker with the commercial plugin language for PL/SQL (http://www.sonarsource.com/products/plugins/languages/plsql/). <br /><br />There are some embedded rule and some are configurable. You can also add your own rule.<br /><br />Code need to be analysed from source.<br /><br />Check the demo here (http://nemo.sonarqube.org/dashboard/index/nl.oracledeveloper:utplsql) on the popular Unit Testing Framework ;-)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-48148069815729088182015-04-01T11:38:33.909-07:002015-04-01T11:38:33.909-07:00I particularly like TVDCC, Trivadis Code Cop for S...I particularly like TVDCC, Trivadis Code Cop for SQL Developer: http://www.salvis.com/blog/downloads/tvdcc-trivadis-plsql-sql-codechecker-for-sql-developer/<br /><br />It checks PL/SQL code against the Trivadis coding guidelines, which are very sensible, so they should suit most developers. Even though you cannot customize the rules themselves, you can disable certain rules.<br /><br />Moreover, it shows metrics such as cyclomatic complexity, and it does not require code to be compiled, so you can use it to check your code before you send it to the DB for compilation.Anonymousnoreply@blogger.com