Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2002
    Posts
    5

    Unanswered: Oracle case sensitive

    Hello,

    Does anybody knows how can I change Oracle to be case sensitive?

    Thanks

  2. #2
    Join Date
    Apr 2002
    Location
    Calgary, Canada
    Posts
    30
    what part of oracle do you want to make case sensitive? It is yor sql code that changes the case. UPPER, LOWER, INITCAP etc.

  3. #3
    Join Date
    Mar 2002
    Posts
    5
    Yes, is about sql area code
    What I'm trying to do is that I don't want to use double quotes("") when I use sql statements. For ex.:
    select sysdate "System_Date" from dual;
    I want to use instead:
    select sysdate System_Date from dual;
    and the result shold be as I wroted, but Oracle is changed to capital letters if I'm not using double quotes.

    Please help!!!
    Last edited by RIancu; 05-28-02 at 10:29.

  4. #4
    Join Date
    May 2002
    Location
    Southern California
    Posts
    4
    Iancule...

    That's just the way Oracle works. You can't change it anywhere in the database to make it case sensitive. I guess that's one [just one] of the benefits that SQL Server has.....

    Alex

Posting Permissions

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