Sample cao.settings.xml file
Published 07 December 2020
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>