What Is PL/SQL Language Case Sensitive

Q

What Is PL/SQL Language Case Sensitive? - Oracle DBA FAQ - Understanding PL/SQL Language Basics

✍: 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.

2007-05-01, 5105👍, 0💬