Re: Can I make oracle case sensitive

From: Prakash V <venkatprakash_at_hotmail.com>
Date: Fri, 10 Sep 1999 16:23:10 GMT
Message-ID: <19990910162311.94400.qmail@hotmail.com>

In Oracle, the table name and column names are always stored in UPPER case only.

Still, both the statements

select * from customers and
select * from Customers will give the same result. But,

select tname from tab where tname like 'customers' will give you no rows selected. But
select tname from tab where tname like 'CUST%' will give you 1 record.
This is the way Oracle is naming the tables and columns.

---

Get Your Private, Free Email at http://www.hotmail.com

 Sent via Deja.com http://www.deja.com/  Share what you know. Learn what you don't. Received on Fri Sep 10 1999 - 11:23:10 CDT