Oracle_Object_Type1.htm
Each DBMS tenders a procedural programming support  as a plug-in, to retrieve complex data with SQL.
Script :

SELECT distinct object_type from user_objects

Intranet:

http://manas8x/BareBone_PHP/Oracle_SQLQuery_Tool_hr.php

Restriction: The user in this scenario, "HR" , is an Admin and also has DBA role