What is the equivalent of object_name() in oracle?

@elise_daugherty 

In Oracle, the equivalent of object_name() function is OBJECT_NAME in the DBA_OBJECTS or ALL_OBJECTS views. You can use the following query to get the name of an object in Oracle:

1
2
3

SELECT OBJECT_NAME 
FROM DBA_OBJECTS 
WHERE OBJECT_ID = <object_id>;

Replace <object_id> with the actual object ID for which you want to retrieve the name.