case sensitive oracle database - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 17 of 17

Thread: case sensitive oracle database

  1. #11
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    If you create a table "Employee" then
    select * from employee
    You'll get ora-942 table or view does not exist
    select * from "Employee" is the only way to address that table

    Drop the double quotes.

    If the software user is naming db objects, don't use double quotes!
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  2. #12
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    First of all, SQLServer means case-sensitive *data*, not object names. You know - as opposed to Oracle, where the data is *always* (very unfortunately) case-sensitive.

    I don't know of any database where the object names are case-sensitive.

    You may want to do a little more digging into database details if you truly want to make a product that works across databases ( a really bad idea, IMHO )

    - Chris
    Christopher R. Long
    ChrisRLong@HotMail.Com
    But that's just my opinion. I could be wrong

  3. #13
    Join Date
    Apr 2001
    Location
    Louisville KY
    Posts
    295
    I have seen the 'case sensitivity' issue before, usually with software developped for multiple databases where the other database (say SQL Server) is case sensitive. Almost always the same situation (a software house with a canned project). I don't like it, but it is your coding headache.

    As for the customer worry, why not just use a definition export as part of your installation process. Create the objects with case sensitivity, export the definitions (ROWS=N) and use that file for installation. If the client changes the installation procedure or objects afterward, they violated your support aggreement, yada yada yada.

    As for the database, the Instance name may be case insensitive (depending on platform, release etc.) but the Oracle doesn't use databases the way other RDBMSs do. A SQL Server instance contains multiple databases which contain schemas. Oracle instances just contain schemas. SQL Server databases can be case sensitive but there is no corresponding object in Oracle.
    Joseph R.P. Maloney, CSP,CDP,CCP
    'The answer is 42'

  4. #14
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    jrpm - are you talking data or object names when you say you've seen the case-sensitivity issue before?

    - Chris
    Christopher R. Long
    ChrisRLong@HotMail.Com
    But that's just my opinion. I could be wrong

  5. #15
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by chrisrlong
    I don't know of any database where the object names are case-sensitive.
    MS Access!
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  6. #16
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    Is that a database? Just kidding... well maybe not.
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  7. #17
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    Originally posted by marist89
    MS Access!
    I just pulled up an Access database, changed the case of one of the object names in one of my queries and ran it and it still ran fine. What makes you think it's case-sensitive?

    - Chris
    Christopher R. Long
    ChrisRLong@HotMail.Com
    But that's just my opinion. I could be wrong

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width