All Products
Search

This Product

    PolarDB:Case sensitivity

    Document Center

    PolarDB:Case sensitivity

    Last Updated:Mar 28, 2026

    In SPL, keywords and user-defined identifiers are case-insensitive. Character and string constants, and data retrieved from external sources, are case-sensitive.

    ElementCase-sensitive?
    KeywordsNo
    User-defined identifiersNo
    Character and string constantsYes
    Data from PolarDB for PostgreSQL (Compatible with Oracle)Yes
    Data from external sourcesYes

    Keywords and identifiers

    Keywords and user-defined identifiers in an SPL program are case-insensitive. The following four statements are equivalent:

    DBMS_OUTPUT.PUT_LINE('Hello World');
dbms_output.put_line('Hello World');
Dbms_Output.Put_Line('Hello World');
DBMS_output.Put_line('Hello World');

    String constants and retrieved data

    Character and string constants are case-sensitive. Data retrieved from PolarDB for PostgreSQL (Compatible with Oracle) or from external sources is also case-sensitive.

    The following statement:

    DBMS_OUTPUT.PUT_LINE('Hello World!');

    Produces this output:

    Hello World!

    The following statement:

    DBMS_OUTPUT.PUT_LINE('HELLO WORLD!');

    Produces this output:

    HELLO WORLD!