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>