Problem Statement: In tables can we use employee_name or emp_name?
Solution: This depends on organization. Many organizations follow emp_name.
Full Name Advantages:
- Easy to Read
- No Confusion
- Oracle supports only 30 char length column names
- Difficult to write queries at command prompt
- Needs Abbreviation map to understand all column Names.
- Column Comments should help in this process.
- Easy to write queries
- Looks simple and easy to write and talk
Here with attached document from Oracle Site for your reference.