Literal object name using quotation marks ""
We create a new table. SQL> create table "HR" . "Test" ( cmp01 number ( 5 ), cmp02 varchar2 ( 10 ) ) ; Table created . But apparently it doesn't exist. SQL> select * from HR . Test ; select * from HR . Test * ERROR at line 1 : ORA - 00942 : table or view does not exist Why doesn't my table exist if i created it ??? SQL> select table_name , owner from dba_tables where table_name = 'TEST' ; no rows selected When you use quotation marks on object name, they will be case sensitive. SQL> select table_name , owner from dba_tables where table_name = 'Test'; TABLE_NAME OWNER ------------------------------ ------------------------------ Test HR For example, using quotation marks you can create different object with same name: SQL> create table "HR"."test&