Code Analysis

Sample cao.settings.xml file

cao.settings.xml

<?xml version="1.0"?>
<Settings xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <TableNames>
    <AllowedPatterns>
      <Value>^tab_</Value>
    </AllowedPatterns>
    <DisallowedPatterns>
      <Value>^dtab</Value>
    </DisallowedPatterns>
  </TableNames>
  <ConstantNames>
    <AllowedPatterns>
      <Value>^con_</Value>
    </AllowedPatterns>
    <DisallowedPatterns>
      <Value>^dcon</Value>
    </DisallowedPatterns>
  </ConstantNames>
  <ExceptionNames>
    <AllowedPatterns>
      <Value>^exc_</Value>
    </AllowedPatterns>
    <DisallowedPatterns>
      <Value>^dexc</Value>
    </DisallowedPatterns>
  </ExceptionNames>
  <CursorNames>
    <AllowedPatterns>
      <Value>^cur_</Value>
    </AllowedPatterns>
    <DisallowedPatterns>
      <Value>^dcur</Value>
    </DisallowedPatterns>
  </CursorNames>
  <FunctionNames>
    <AllowedPatterns>
      <Value>^fn_</Value>
    </AllowedPatterns>
    <DisallowedPatterns>
      <Value>^dfn</Value>
    </DisallowedPatterns>
  </FunctionNames>
  <ProcedureNames>
    <AllowedPatterns>
      <Value>^prc_</Value>
    </AllowedPatterns>
    <DisallowedPatterns>
      <Value>^dprc</Value>
    </DisallowedPatterns>
  </ProcedureNames>
  <PackageNames>
    <AllowedPatterns>
      <Value>^pack_</Value>
    </AllowedPatterns>
    <DisallowedPatterns>
      <Value>^dpack</Value>
    </DisallowedPatterns>
  </PackageNames>
  <VariableNames>
    <AllowedPatterns>
      <Value>^var_</Value>
    </AllowedPatterns>
    <DisallowedPatterns>
      <Value>^dvar</Value>
    </DisallowedPatterns>
  </VariableNames>
  <TypeNames>
    <AllowedPatterns>
      <Value>^type_</Value>
    </AllowedPatterns>
    <DisallowedPatterns>
      <Value>^dtype</Value>
    </DisallowedPatterns>
  </TypeNames>
  <IssueSettings>
    <CGUNP>Error</CGUNP>
    <StarInSelect>Error</StarInSelect>
    <CreateUserStatement>Error</CreateUserStatement>
    <GrantStatement>Error</GrantStatement>
    <CreateTableStatement>Error</CreateTableStatement>
    <CreateIndexStatement>Error</CreateIndexStatement>
    <AlterSystemStatement>Error</AlterSystemStatement>
    <DeleteWithoutWhere>Error</DeleteWithoutWhere>
    <UpdateWithoutWhere>Error</UpdateWithoutWhere>
    <ColumnNameIsReservedWord>Error</ColumnNameIsReservedWord>
    <SchemaRequired>Error</SchemaRequired>
    <InsertColumnList>Error</InsertColumnList>
    <UseAnsiJoins>Error</UseAnsiJoins>
    <AvoidNaturalJoin>Error</AvoidNaturalJoin>
    <UseNameInOrderBy>Error</UseNameInOrderBy>
    <UseTableAliases>Error</UseTableAliases>
    <DefaultOnNull>Error</DefaultOnNull>
    <InitVarWithNull>Error</InitVarWithNull>
    <CompareWithNull>Error</CompareWithNull>
    <NeverUseQuotedIdentifier>Error</NeverUseQuotedIdentifier>
    <AvoidROWID>Error</AvoidROWID>
    <NumberWithoutPrecision>Error</NumberWithoutPrecision>
    <AvoidLongDataType>Error</AvoidLongDataType>
    <AvoidCharDataType>Error</AvoidCharDataType>
    <AvoidVarCharDataType>Error</AvoidVarCharDataType>
    <UseCharSemantic>Error</UseCharSemantic>
    <UseCaseInsteadDecode>Error</UseCaseInsteadDecode>
    <UseCoalesceInsteadNvl>Error</UseCoalesceInsteadNvl>
    <DoNotUseGoto>Error</DoNotUseGoto>
    <LabelYourLoops>Error</LabelYourLoops>
    <UseExitWhenInsteadOfIfExit>Error</UseExitWhenInsteadOfIfExit>
    <FunctionMustEndWithReturn>Error</FunctionMustEndWithReturn>
    <VariableNameConvention>Error</VariableNameConvention>
    <ConstantNameConvention>Error</ConstantNameConvention>
    <CursorNameConvention>Error</CursorNameConvention>
    <ExceptionNameConvention>Error</ExceptionNameConvention>
    <FunctionNameConvention>Error</FunctionNameConvention>
    <ProcedureNameConvention>Error</ProcedureNameConvention>
    <DoNotIgnoreExceptions>Error</DoNotIgnoreExceptions>
    <EncapsulateInPackage>Error</EncapsulateInPackage>
    <PackageNameConvention>Error</PackageNameConvention>
    <RaiseApplicationError20k>Error</RaiseApplicationError20k>
    <AvoidDistinct>Error</AvoidDistinct>
    <UseUnionAll>Error</UseUnionAll>
    <UseHavingWithGroupBy>Error</UseHavingWithGroupBy>
    <TypeNameConvention>Error</TypeNameConvention>
    <RownumSameLevelOrderBy>Error</RownumSameLevelOrderBy>
    <UseExistsInsteadOfIn>Error</UseExistsInsteadOfIn>
    <BewareDataValueLists>Error</BewareDataValueLists>
    <UseHavingWithAgg>Error</UseHavingWithAgg>
    <INModeExplicit>Error</INModeExplicit>
    <UseASWithAlias>Error</UseASWithAlias>
    <!--
    <UseEquijoins>Error</UseEquijoins>
    -->
    <OrderByInSubquery>Error</OrderByInSubquery>
    <CloseOpenedCursor>Error</CloseOpenedCursor>
    <DoNotGoBack>Error</DoNotGoBack>
    <LoopLabelMatch>Error</LoopLabelMatch>
    <CloseOpenedCursor>Error</CloseOpenedCursor>
    <DoNotUseWeakRefCursor>Error</DoNotUseWeakRefCursor>
    <CRLFInStringLiteral>Error</CRLFInStringLiteral>
    <CreateOrReplace>Error</CreateOrReplace>
    <AvoidLoop>Error</AvoidLoop>
    <FuncOutParam>Error</FuncOutParam>
    <ToNumberFormat>Error</ToNumberFormat>
    <VarNull>Error</VarNull>
    <CaseWithoutElse>Error</CaseWithoutElse>
    <BlockLabelMatch>Error</BlockLabelMatch>
    <DbmsSqlUsed>Error</DbmsSqlUsed>
    <OldStyleJoin>Error</OldStyleJoin>
    <OrderByExplicit>Error</OrderByExplicit>
    <CompoundTrigger>Error</CompoundTrigger>
    <LargeInList>Error</LargeInList>
    <CrossJoinUsed>Error</CrossJoinUsed>
    <TooBigJoin>Error</TooBigJoin>
    <NestedSubQuery>Error</NestedSubQuery>
    <DTFormatModel>Error</DTFormatModel>
    <PutLine>Error</PutLine>
    <RedundantBoolean>Error</RedundantBoolean>
    <FullJoin>Error</FullJoin>
    <LikeStartWildcard>Error</LikeStartWildcard>
    <UseWhenOthers>Error</UseWhenOthers>
    <TableNameConvention>Error</TableNameConvention>
  </IssueSettings>
  <SettingsGuid>76605f21-ff3b-463f-8f3b-00bb51c4ef2f</SettingsGuid>
</Settings>

Didn't find what you were looking for?