In Oracle Database, TABLEs, PROCEDUREs, FUNCTIONs, and PACKAGES or considered objects.
Object type could be the following:
TABLE
FUNCTION
PROCEDURE
PACKAGE
PACKAGE BODY
SYNONYM
Question:
How would you know the object type of a specific object name?
Answer:
Oracle has special tables which are called as the Data Dictionary Views. Oracle has a special table called USER_OBJECTS. It contains information about the tables in a specified schema.
You can issue the SQL query below to know the object type of a specific object name. For example, if you have a table with name EMPLOYEES, you can type the following query to know its object type:
SELECT object_type
FROM user_objects
WHERE object_name = ‘EMPLOYEES’;
Here’s the output:
OBJECT_TYPE
——————-
TABLE