Keywords and user-defined identifiers that are used in an SPL program are not case-sensitive.
For example, DBMS_OUTPUT.PUT_LINE('Hello World');
is interpreted as the same content as dbms_output.put_line('Hello World');
, Dbms_Output.Put_Line('HelloWorld');
, or DBMS_output.Put_line('HelloWorld');
.
Character and string constants are case-sensitive. Data retrieved from PolarDB for PostgreSQL(Compatible with Oracle) or obtained from other external sources is also case-sensitive. The DBMS_OUTPUT.PUT_LINE('Hello World!') ;
statement generates the following output:
Hello World!
However, the DBMS_OUTPUT.PUT_LINE('HELLO WORLD!') ;
statement generates the following output:
HELLO WORLD!