Re: possible Class::DBI::Oracle [patch]

[prev] [thread] [next] [Date index for 2005/04/22]

On Fri, Apr 22, 2005 at 11:10:57AM +0100, Carl Johnstone wrote:
> 
> >My oracle10g isn't case sensitive about table or schema names...
> 
> It depends where, if you're talking about table meta-data then that is 
> case-sensitive - compare:
> 
> SELECT * FROM user_tables WHERE table_name = 'MY_TABLE'
> 
> 
> SELECT * FROM user_tables WHERE table_name = 'my_table'
 
Just to clarify, all we're saying in this whole thread is that Oracle
respects case only for quoted values. 

Since you must quote the table_name value in the above statement in
order to have valid SQL, you're forced to respect the case of the table
definition. In fact the above example doesn't tell us much without
knowing what that was. Which of these did we have?

CREATE TABLE my_table ... -- upper case by default
CREATE TABLE "my_table" ...
CREATE TABLE "My_Table" ...
...

To return to Carl's example, compare these:

SELECT * FROM "user_tables" WHERE "table_name" = 'MY_TABLE'
SELECT * FROM "USER_TABLES" WHERE "TABLE_NAME" = 'MY_TABLE'
 
> Carl > 

HTH!
David