When a constraint is created in Oracle without explicitly naming it, Oracle automatically generates a system constraint name in the format SYS_Cn where n is an incremental number. For example: SYS_C1234, SYS_C5678. This distinguishes system-generated names from user-defined constraint names.