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;