-
My question is if I connect a database on Unix and use "select * from emp;" to query.
Is the command case sensitive or not?
-
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;
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|