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
x, o |
Result of the Function GET_OBJECTNAME(x,o) |
---|---|
x identifies an object that is not of object type o |
|
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 database user.