All _ view of Oracle Data Dictionary

The ALL _ view returns information about ALL objects that a user can access without considering its owner. For example, a query of ALL_TABLES not only returns a list of all user-owned Relational Tables, but also returns a list Of all Relational Tables that the owner explicitly grants access to the user. The following query returns information about all objects that the user has the right to access. [SQL] SQL> SELECT object_name, object_type FROM all_objects; various tables in the www.2cto.com ALL _ view are as follows: table description ALL_TABLES contains the owner of all accessible tables and the name of these tables ALL_CATALOG contains the owner of all accessible tables, views, and synonyms, and the corresponding name and type ALL_OBJECTS contains the owner of accessible database objects. its type and name ALL_TRIGGERS include the owner of the database trigger that can be accessed and its type and name ALL_USERS storage information about the user ALL_CONSTRAINTS description constraints of the table that the current user can access define ALL_PROCEDURES to list all functions, procedures, and table Example 5 of the associated attribute ALL _ view demonstrates the use of the ALL_TABLES view. [SQL] SQL> SELECT owner, table_name, tablespace_name from all_tables where table_name like 'B % '; this example shows the table owner, table name, and table space name starting with "B" in the ALL_TABLES view. Example 6 shows how to use the ALL_USERS view. [SQL] SQL> SELECT * from all_users where user_id> 4 and user_id <50; this example shows all users whose IDs are greater than 4 and less than 50 in the ALL_USERS view. Example 7 of www.2cto.com demonstrates the use of the ALL_CONSTRAINTS view. [SQL] SQL> SELECT constraint_name, owner, table_name from all_constraints where table_name like 'B % '; this example shows the Table constraint name, table owner, and table name starting with "B" in the ALL_CONSTRAINTS view. Example 8 demonstrates the use of the ALL_PROCEDURE view. [SQL] SQL> SELECT owner, procedure_name from all_procedures where owner like 'q % '; this example shows the owner and process name starting with "Q" in the ALL_PROCEDURES view. Author jason5186