| Lesson 7 | Naming conventions |
| Objective | Create a naming convention in Oracle. |
Naming conventions, which are often overlooked because they do not seem to be important, do not become an issue until they are not implemented.
A lack of naming conventions causes developers to spend their valuable time trying to debug and maintain the application code.
Naming conventions
A lack of naming conventions causes developers to spend their valuable time trying to debug and maintain the application code.
Below are the common naming conventions:
Standards provide a common language for everyone in the team to understand and maintain the code easily.
The next lesson concludes this module.
-
Use a naming convention to avoid ambiguity in the code.
-
Avoid using the same name for the database column and variables in your code.
-
Adopt a naming convention for various objects such as the following example: Using v_ as a prefix representing a variable and
g_ as a prefix representing a global
variable avoids naming conflicts with database objects.
vg_petname VARCHAR2(30);
Standards provide a common language for everyone in the team to understand and maintain the code easily.
Naming Conventions - Exercise
Click the Exercise link below to build a naming convention for your application.
Naming Conventions - Exercise
Naming Conventions - Exercise