Plsql Review App

這個應用程序通過給予快速可視快照可以幫助用戶回顧PLSQL源代碼

This app takes users input plsql file (package, procedures script) and publishes Insights on source code with visual charts and in tabular format.

Plsql Review Tool is a handy solution for code reviewers; it helps quickly gathers important stats about the code to determine the efficiency of the program. It can also serve Estimation purpose to assess complexity of the Plsql Program. Instead of browsing the code line by line manually, a code reviewer can use this tool to pin point grave program errors by instantly tracking down to the exact line of code. The tool checks for proper usage of variables, hard coded values, control or conditional statements, exception handling etc., It highlights the code areas where redundant usage like SELECT statements, referring same table appear.

The tool has a very user-friendly and convenient interface where the user can simply specify the file name, click review and the tool generates useful insights. The Code Profile summary and the File contents sections are neatly color-coded for easy identification. User can also easily navigate to the preferred line of code by clicking the line number. The CRUD Statement section on the interface that displays SELECT, UPDATE, INSERT and DELETE statements separately for effective review of sql statements used within the package.

App is helpful for Plsql Developers who develop, modify, maintain or support database objects based on SQL, PLSQL code e.g. Procedures, packages, triggers, functions etc.