Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2010
    Posts
    2

    Unanswered: Are Oracle object names converted to uppercase when created?

    Just created a user (in lowercase) and it was added to database (using sqlplus terminal session) as uppercase.

    Does Oracle (10g2) do this when creating all types of database object (I hope so for consitency's sake!)

    Searched Oracle site documentation and cannot find case sensitivity mentioned in this context.

    thanks

  2. #2
    Join Date
    Nov 2003
    Posts
    2,933
    Provided Answers: 12
    Quote Originally Posted by ksdmnv View Post
    Just created a user (in lowercase) and it was added to database (using sqlplus terminal session) as uppercase.

    Does Oracle (10g2) do this when creating all types of database object (I hope so for consitency's sake!)
    Yes, unless you quote the name using double quotes
    This is required by the ANSI standard.

    fooBAR, FOObar, foobar and FOOBAR are all the same name
    but "fooBAR" is different to "FOObar".

    Searched Oracle site documentation and cannot find case sensitivity mentioned in this context.
    See here: http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/sql_elements008.htm#i27561

  3. #3
    Join Date
    Jun 2010
    Posts
    2
    Hi shammat - thanks for clearing that up.

Posting Permissions

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