Using Quotation Marks

Within quotation marks, owner is case sensitive. Quotation marks instruct the database server to read or store the name exactly as typed when you create or access a database object. For example, suppose that you have a table whose owner is Sam. You can use either one of the following two statements to access data in the table:

SELECT * FROM table1;
SELECT * FROM 'Sam'.table1;

The first query succeeds because the owner name is not required. The second query succeeds because the specified owner name matches the owner name as it is stored in the database.