Home » SQL & PL/SQL » SQL & PL/SQL » case sensitivity in table names: when from?
case sensitivity in table names: when from? [message #340746] Thu, 14 August 2008 02:21 Go to next message
obakesan
Messages: 1
Registered: August 2008
Location: Finland
Junior Member
Hi

I've been away from Oracle for a few years now, in the past I worked on versions up until 8i. I'm now playing with 10g at home now and seem to be finding a few "new" things.

One which (I think) I've found is case sensitivity on the table names. I thought they were not case senstive in the past, but could be wrong.

Eg

SQL> select count(*)
  2  from all_ind_columns 
  3  where table_name = 'product_master'
  4  /

  COUNT(*)
----------
         0

SQL> ed
Wrote file afiedt.buf

  1  select count(*)
  2  from all_ind_columns
  3* where table_name = 'PRODUCT_MASTER'
SQL> /

  COUNT(*)
----------
         3



is this something which was always there or was it introduced some time and I missed it?

thanks Smile
Re: case sensitivity in table names: when from? [message #340747 is a reply to message #340746] Thu, 14 August 2008 02:26 Go to previous messageGo to next message
rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA
Senior Member
EveryObject names are stored in Capital Letters while creation.

String comparison's are case sensitive.

These can be in small letters only when you place them in " " tags.

Regards,
Rajat
Re: case sensitivity in table names: when from? [message #340750 is a reply to message #340746] Thu, 14 August 2008 02:35 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Object names are case insensitive (by default) and converted to upper case but there you don't use object_name you compare 2 strings table_name field and 'product_master' and strings comparison is case sensitive (by default).

Regards
Michel
Previous Topic: What's wrong with this PROC?
Next Topic: One Time Only Procedure
Goto Forum:
  


Current Time: Fri Dec 09 22:55:01 CST 2016

Total time taken to generate the page: 0.07437 seconds