Case sensitivity v15

Suggest edits

Keywords and user-defined identifiers that are used in an SPL program are case insensitive. For example, the statement DBMS_OUTPUT.PUT_LINE('Hello World'); is interpreted the as dbms_output.put_line('Hello World'); or Dbms_Output.Put_Line('Hello World'); or DBMS_output.Put_line('Hello World');.

Character and string constants, however, are case sensitive. Data retrieved from the EDB Postgres Advanced Server database or from other external sources is also case sensitive.

The statement DBMS_OUTPUT.PUT_LINE('Hello World!'); produces the following output:

Output
Hello World!
The statement DBMS_OUTPUT.PUT_LINE('HELLO WORLD!'); produces this output:
Output
HELLO WORLD!
← Prev
Basic SPL elements
Next →
Identifiers