PL/SQL Language Case Insensitive in Oracle


Is PL/SQL Language Case Sensitive in Oracle?



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.


Enter Comments in PL/SQL in Oracle

Understanding PL/SQL Language Basics

Understanding PL/SQL Language Basics

⇑⇑ Oracle Database Tutorials

2018-12-26, 3342🔥, 0💬