You can use simple, qualified, remote, or qualified and remote names to reference identifiers.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support this feature.
If an identifier is declared in a named PL unit, you can (sometimes must) use its qualified name to reference it. The syntax is as follows:
unit_name.simple_identifier_name
For example, if the program unit ob declares the identifier c, you can use the qualified name ob.c to reference it. The unit name can also (sometimes must) be qualified. If the identifier is not visible, you must qualify it (see Scope and visibility of identifiers).
If the identifier is declared in a remote database, you must use its remote name to reference it. The syntax is as follows:
simple_identifier_name@link_to_remote_database
If the identifier is declared in a remote database, you must use its qualified remote name to reference it. The syntax is as follows:
unit_name.simple_identifier_name@link_to_remote_database
