PL/SQL Language Case Insensitive in Oracle

Q

Is PL/SQL Language Case Sensitive in Oracle?

✍: FYIcenter.com

A

PL/SQL language is not case sensitive:

  • Reserved words are not case sensitive. For example: CASE and Case are identical.
  • Variable names and other names are not case sensitive. For example: TOTAL_SALARY and total_salary are identical.

But values in string literals are case sensitive. For example: 'DBA' and 'dba' are different.

 

Understanding PL/SQL Language Basics

⇒⇒Oracle Database Tutorials

2016-10-17, 173👍, 0💬