case sensitive oracle database
I have to create a case-sensitive database in Oracle.
Here I am taking about the table names, column names and all the database objects only, I am not talking about the data.
I want to create a case sensitive database.
Then I will create table EMPLOYEE
I want whenever somebody writes
SELECT * FROM employee
it should say, no table with this name
if somebody writes
SELECT * FROM EMPLOYEE
it should give result.
First of all I want to know, is it possible in Oracle ?