DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: the command case sensitive or not?

  1. #1
    Join Date
    Jul 2001
    Posts
    8
    My question is if I connect a database on Unix and use "select * from emp;" to query.
    Is the command case sensitive or not?

  2. #2
    Join Date
    Jan 2000
    Posts
    387
    Hi,

    The command is not case sensitive. The following 2 statements will return the same results, but it will be stored as 2 different statements in the buffers thus affecting performance if the query is big.

    /* Statement 1 */
    select * from emp;

    /* Statement 2 */
    Select * From EMP;

  3. #3

    not case sensitive

    In general, Oracle is not case sensitive by default. You can make it so if you wish by createing object with names enclosed within quotes..this is generally not a good idea though :-0

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