GET_OBJECTNAME(x,o) 

The string function GET_OBJECTNAME(x,o) returns the name of the database object.

Identifier of the object: x

The argument x is a string literal in the format[<schema_name>.]<identifier> or a character parameter of this type. Schema schema_name or identifier identifier can be special identifiers.

Object type: o

You can use one of the following key words:

·        DBPROC[EDURE]: Database procedure

·        DOMAIN: Domain

·        SEQUENCE: Sequence

·        SYNONYM: Synonym

·        VIEW: View table

·        TABLE: Table

	Result of the GET_OBJECTNAME(x,o) Function
x identifies an object that is not of object type o	NULL value
Object x does not exist	NULL value
Object x exists, however the current user does not have any privileges for this object	NULL value
Object x exists for the schema specified under schema_name and the current user has a privilege for this object	identifier
Object x exists, and the current user has a privilege for this object	First object name found in the search hierarchy

For some object types, there is no search hierarchy. In this case, the function only searches for the object in the schema of the current user.