PRODUCTS         DOWNLOADS         BUY NOW         SUPPORT         COMPANY          
 
 
ClearSQL for Oracle
  FULL DESCRIPTION  |  AT A GLANCE  |  WHY ClearSQL |  SCREENSHOTS  |  RULES FOR AUDIT  |  SYSTEM REQUIREMENTS 
 

ClearSQL for Oracle contains nearly 60 rules for best-practices coding. Below is the complete list.

Program Structure

1

Use a NULL statement

2

Use of GOTO

3

Use of a backward GOTO

4

GOTO used in a loop

5

An EXIT statement is used in a FOR loop

6

An EXIT statement is used in a WHILE loop

7

A RETURN statement is used in a FOR loop

8

A RETURN statement is used in a WHILE loop

9

A RETURN statement is used in a PROCEDURE

10

FUNCTION does not contain a RETURN statement

11

FUNCTION with more than one RETURN statement in the executable section

12

Presence of more than one exit point from a loop

13

FUNCTION has no parameter

14

PROCEDURE has no parameter

15

FUNCTION has OUT parameter

16

Mode of parameter is not specified with IN parameter

17

This definition hides another one

18

Unreferenced parameter

19

Unreferenced local procedure/function

20

Unreferenced loop index

21

Loop index redeclared

22

Procedure calls itself recursively (Program calls itself recursively)

23

CASE without ELSE (DEFAULT) section

24

Last statement in function must be a RETURN

25

This function exception handler does not contain a RETURN statement

26

Exception masked by a NULL statement

27

Global public variables defined in package specification

28

Exception not handled inside unit

29

Raise of a predefined exception

30

An exception is raised and handled in the same scope

31

DELETE or UPDATE without WHERE clause

32

Place default parameters at the end of the formal parameter list

33

The initialization section of the package body contains RETURN statement

34

Function interface complexity metric exceeds the specified maximum

35

Function parameter complexity metric exceeds the specified maximum

36

Functional complexity metric exceeds the specified maximum

37

Cyclomatic complexity v(G) [McCabe] exceeds the specified maximum

Readability

38

Initialization to NULL is superfluous

39

END of program unit or package is not labelled

40

END of labelled block should also be labelled

41

END of labelled LOOP should also be labelled

42

The label near the END of the block doesn't match the block label, or a block label is missing

43

The label near the END of the loop doesn't match the loop label, or a loop label is missing

44

An EXIT statement in a labelled loop should have the loop's label

45

Nested loops should all be labelled

46

IF..THEN..EXIT should be replaced by EXIT WHEN

47

END of CASE statement should also be labelled

48

Elements in the SELECT list (columns/expressions) are not qualified by a table/view name

49

Complex expression not fully parenthesized

Maintainability

50

Local program unit reference to an external variable

51

Cursor reference to an external variable (use a parameter)

52

Positional parameters used instead of named parameters when having more then 6 parameters

53

Specify a full column list (as opposed to using '*') in each DML statement and cursor

54

Minimum function comment percentage

55

eLOC exceeds the specified maximum



Rules for Audit

You can select the rules to be applied.


 
 
  Webdesign done by on-designs.com. For further information please visit our webpage. Thank you for your interest!   Privacy Policy    Copyright    Contact
© 2008 Conquest Software Solutions, LLC. All rights reserved.