Virtuoso supports multiple namespaces for tables and procedures. A table or procedure is uniquely identified by a three part name consisting of qualifier, owner and name separated by dots.
Each connection has a current qualifier which is used as the default qualifier for if a name does not specify a qualifier. The owner can be omitted from a name if the qualifier and name uniquely identify the object, e.g. DB..SYS_KEYS.
Initially, all system objects have the qualifier DB and owner DBA.
The default current qualifier of all connections is DB unless otherwise specified using db.dba.user_set_qualifier.
A user can be assigned a default qualifier set as current qualifier upon login. This is done with the stored procedure db.dba.user_set_qualifier.
user_set_qualifier (in user varchar, in qualifier varchar)
The default qualifier of the user is set to be the qualifier. The names are strings and thus case sensitive.
Example:
db..user_set_qualifier ('U1', 'U1DATA');
This sets the default qualifier for the connection in question. The identifier cannot be an expression. The identifier is subject to whatever case conversions may be in effect.
A quoted identifier will always pass in the case it is entered. An unquoted identifier will be converted to upper case if CaseMode so specifies.
Previous
Wide Character Identifiers |
Chapter Contents |
Next
Literals, Brace Escapes |