Mark, Question: Oracle Case Sensitive SQL? Answer: Yes AND No
If I create my table like this: CREATE TABLE MaxCoolTable AS ( ... ) I can now do SELECT * FROM MaxCoolTable or SELECT * FROM MAXCOOLTABLE or SELECT * FROM maxcooltable Not case sensitive eh? BUT!!!!! If I had created my table like this: CREATE TABLE "MaxCoolTable" AS ( ... ) I can ONLY do this: SELECT * FROM MaxCoolTable The other two will fail. NOTE: This is also true for column names and anything else you can think of like views, stored procedures, etc. Some tools (and this is how I figured this out some years ago) will put quotes around all the names it can find which might cause some serious headache and crying late at night ;) /Max Mark Mandel wrote: > I didn't think Oracle was, but it's the only thing that is making sense atm - > > I've got some unit tests for Transfer, and I'm trying to get it > working with Oracle, and I can't work out why it isn't. > > I keep getting errors like: > -- > [Macromedia][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not > exist > select MAX(IDBasic) as maximumID from tbl_basic > -- > > If I run this in TOAD, it runs fine, which confuses me. > > I made my create table script run all in uppercase, thinking that may > have been the issue, but nope. > > And the funny thing is, it seems to only happen on SOME tables. > > Back when I was using Oracle, I don't remember having this issue. > > Can anyone shed some light? > > Mark > > > -- > E: [EMAIL PROTECTED] > W: www.compoundtheory.com --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~----------~----~----~----~------~----~------~--~---
