Some helpful queries related to alias sets are described here. These queries are based on the information provided in this chapter.
The following query retrieves aliases (names, values, and types) present in an alias set:
SELECT alias_name, alias_value, alias_category FROM dm_alias_set WHERE object_name = 'zone1_aliases'
The following query assigns an alias set (using its object ID) to a sysobject explicitly:
UPDATE dq_loan_app OBJECTS SET r_alias_set_id = '6600001080000500' WHERE object_name = 'LoanApp_1234567890.txt'
r_alias_set_id can be modified like this even though its name starts with
The following query retrieves the performer names for an activity:
SELECT performer_name FROM dm_activity WHERE object_name ...