Trivadis PL/SQL & SQL CodeChecker Released

In August 2009 Trivadis – the company I work for – released the first version of their PL/SQL & SQL Coding Guidelines. Back then we made our PL/SQL assessments based on interviews and checked the code against our guidelines using Code Xpert, SQL*Plus scripts and some manual/visual checks. You may imagine that this approach had some shortcomings, especially if you think about repeating the process after some corrections.

Back than the idea was born to build a tool which allows to run the checks fully automated and make it part of our continuous integration environment.

Today I’m proud to release the first public beta version of TVDCC – the Trivadis PL/SQL & SQL CodeChecker. TVDCC is a file based command line utility and does not require a connection to an Oracle database at any time. Simply run

tvdcc path=.

to scan the current directory including all subdirectories for SQL*Plus files and to create HTML and Excel reports.

See mydownload areafor more information about TVDCC and to grab your copy of TVDCC. Any feedback is highly appreciated.

您可能感兴趣的

Kapacitor之TICK脚本,监控输出 好久没更新博客园了,说来也惭愧,之前说好每隔几天更新一个的,虽然没什么人看,但是作为一个记录,回顾也是能有新的认识,这篇博客是讲的目前我在工作中使用的一个结束点,这个技术点目前网上资料少之甚少,也是希望给刚接触的人一个大概的思路,稍作分析下。说了这么多其实我也是个半吊子,也就间接性的踌躇满志,...
Laravel sql searches for the 3rd relationship I want to show all users who have a permission name of "Manager" I have the following databases users (many to many relationship with roles) | id:...
Change SQL Server Collation – Back to Basics One of my most favorite things in the world is the opportunity to deal with extremely varying database and environment requirements. Many vendors...
Laravel sql searches for the 3rd relationship I want to show all users who have a permission name of "Manager" I have the following databases users (many to many relationship with roles) | id:...
责编内容来自:Philipp Salvisberg's Blog (源链) | 更多关于

阅读提示:酷辣虫无法对本内容的真实性提供任何保证,请自行验证并承担相关的风险与后果!
本站遵循[CC BY-NC-SA 4.0]。如您有版权、意见投诉等问题,请通过eMail联系我们处理。
酷辣虫 » Trivadis PL/SQL & SQL CodeChecker Released



专业 x 专注 x 聚合 x 分享 CC BY-NC-SA 4.0

使用声明 | 英豪名录