From the course: Oracle Database 12c: Basic SQL

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Case sensitivity of SQL commands

Case sensitivity of SQL commands - Oracle Database Tutorial

From the course: Oracle Database 12c: Basic SQL

Start my 1-month free trial

Case sensitivity of SQL commands

“

- [Instructor] Note that by default, the syntax of the SQL language in the Oracle database is not case-sensitive. So for example, writing select star from employees, and we'll get exactly to what does this command actually do later in our course. But note that writing the query all in lowercase will function just as well if we change some of the words to uppercase. So for example, switching from to from, all in uppercase, and switching select to select with a capital S, will actually function the same. Similarly, the same holds true for Oracle table names. So changing the P and the L in employees to uppercase, we will still be able to execute our query. There are some specific occasions where case sensitivity is important, such as when filtering based on string values, but we'll explore that in greater details throughout the course. Also note that SQL developer has a cool feature where you can highlight a section of your SQL query, and by pressing the following icon, you can change…

Contents