solution to using database functions with oracle

try to use capital letters in table names
for example :
dont write

PHP Code:

// dont write 
$this->db->get('employee'); 


but write

PHP Code:

// but write
$this->db->get('EMPLOYEE'); 


and the same for columns name

This is not a good idea unless they were defined this way to begin with. SQL keywords are case-insensitive, but long-standing convention means most people use all-caps for them. The same convention usually defines table and column names in all-lowercase, making it easier to distinguish the difference in raw SQL. However, whether table and column names are case-sensitive is sometimes a configurable option, and, therefore, may change from one environment to the next.

For these reasons, the most important thing to remember is to be consistent with your table and column names. Never suggest to someone that they should change the case of these names in their code unless there is evidence that they have been inconsistent.

Bonfire

Practical CodeIgniter 3
CodeIgniter Testing Guide