Multiple choice

When using SQL*Plus, Oracle commands, column names, table names and all other database elements ____.

  1. are case insensitive

  2. are case sensitive

  3. must always be in lower case

  4. must always be in upper case
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Oracle SQL*Plus is case insensitive for commands, table names, column names, and other database elements. 'SELECT * from employees' works the same as 'select * FROM EMPLOYEES'. However, string literals in WHERE clauses remain case sensitive.

Keep practicing — related questions