Shulou(Shulou.com)05/31 Report--

It is believed that many inexperienced people have no idea about how to use all_ view in Oracle. Therefore, this article summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem.

Data dictionary related connections:

Oracle data Dictionary: common Dictionary

Oracle data dictionary: user_ view

The ALL_ view returns information about all objects that the user can access, regardless of their owners. For example, a query against ALL_TABLES returns not only a list of all relational tables owned by the user, but also a list of all relational tables that its owner explicitly authorized the user to access.

The following query returns information about all objects that the user has access to.

SQL > SELECT object_name, object_type FROM all_objects

The various tables in the ALL_ view are as follows:

Table description

ALL_TABLES contains the owners of all accessible tables and the names of those tables

ALL_CATALOG contains the owners of all accessible tables, views, and synonyms and their corresponding names and types

ALL_OBJECTS contains the owner of the accessible database object and its type and name

ALL_TRIGGERS contains the owner of the accessible database trigger and its type and name

ALL_USERS stores information about users

ALL_CONSTRAINTS describes the constraint definition of the table that the current user can access

ALL_PROCEDURES lists all functions, procedures, and associated properties

Tables in the ALL_ view

Example 5 demonstrates the use of the ALL_TABLES view.

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 in the ALL_TABLES view whose table name starts with "B".

Example 6 demonstrates the use of the ALL_USERS view.

SQL > SELECT * from all_users where user_id > 4 and user_id SELECT constraint_name, owner, table_name from all_constraints where table_name like'B%'

This example shows the table bundle name, table owner, and table name that start with "B" in the ALL_CONSTRAINTS view.

Example 8 demonstrates the use of the ALL_PROCEDURE view.

SQL > SELECT owner, procedure_name from all_procedures where owner like'Q%'

This example shows the owner and procedure name that starts with "Q" in the ALL_PROCEDURES view.

After reading the above, have you mastered how to use the all_ view in Oracle? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.