Home

Object attributes should comply with a naming convention

Rule description

  • Object attributes should comply with a naming convention

 

Non-compliant Code Example

CREATE TYPE CUSTOMER_T AS OBJECT
( 
    FirstName_ VARCHAR2(50),    --Non compliant code (Not comply with naming convention)
    LastName_ VARCHAR2(50),     --Non compliant code (Not comply with naming convention)
    Area VARCHAR2(100),
    City VARCHAR2(100)
);

Compliant Code Example

CREATE TYPE CUSTOMER_T AS OBJECT
( 
    FirstName VARCHAR2(50),    --Compliant code (Comply with naming convention)
    LastName VARCHAR2(50),     --Compliant code (Comply with naming convention)
    Area VARCHAR2(100),
    City VARCHAR2(100)
);
Visual Expert 2020
 VEPLSQLRULE116