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.

 

Enter Comments in PL/SQL in Oracle

Understanding PL/SQL Language Basics

Understanding PL/SQL Language Basics

⇑⇑ Oracle Database Tutorials

2018-12-26, 3160🔥, 0💬