Hi Friends,
After a long time i got interest to write something and today's containt for Database.
Table sturcture which is not defined in DB-user but in schema. it's related to user also.
After a long time i got interest to write something and today's containt for Database.
Table sturcture which is not defined in DB-user but in schema. it's related to user also.
Difference b/w all_object ,user_object, dba_objects
all_objects is show you all objects of current and those object which you have rights to access.
dba_objects show all object of all users.
user_objects show you the current user objects.