Request for a new Code Analysis Rule: Some columns types are not allowed (4332858)

RESOLUTION

1. Go to View | Toad options | Code Analysis |General and, on the right panel select Edit Rules
2. Click on Create New Rule
3. Enter the Description, the tip and the XPath Expression provided below

//CREATE/TABLE/COLUMN_SPEC
    [TYPE/QNAME/@value=("blob", "timestamp")]
       /QNAME

See if this rule works:

If we create the  table below:

CREATE TABLE za_testRules
(
    col1    NUMBER,
    col2    blob
)

we get rule 7004:

If we change the column type to number for example, rule 7004 should disappear:

STATUS