Home
Identifiers should be written in lower case
Rule description
- Identifiers should be written in lower case
Non-compliant Code Example
DECLARE oracleQuery VARCHAR2(600); --Non complaint code (Identifiers are in mixed case) new_Custid NUMBER(8); --Non complaint code (Identifiers are in mixed case) new_FirstName VARCHAR2(50); --Non complaint code (Identifiers are in mixed case) new_LastName VARCHAR2(50); --Non complaint code (Identifiers are in mixed case) BEGIN oracleQuery := 'BEGIN CreateCustomer(:id, :Fname, :Lname); END;'; EXECUTE IMMEDIATE oracleQuery USING IN OUT new_Custid, new_FirstName, new_LastName; END;
Compliant Code Example
DECLARE oracle_query VARCHAR2(600); --Compliant code (Identifiers are in lower case) new_custid NUMBER(8); --Compliant code (Identifiers are in lower case) new_first_name VARCHAR2(50); --Compliant code (Identifiers are in lower case) new_last_name VARCHAR2(50); --Compliant code (Identifiers are in lower case) BEGIN oracle_query := 'BEGIN CreateCustomer(:id, :Fname, :Lname); END;'; EXECUTE IMMEDIATE oracle_query USING IN OUT new_custid, new_first_name, new_last_name; END;