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

This article introduces you how to use user_view in Oracle, the content is very detailed, interested friends can refer to it, I hope it can help you.

Data Dictionary Related Links:

Oracle Data Dictionary: Common Dictionary

Tables store information about relational databases, and only Oracle databases can read and write to these tables. Most users cannot access these tables because most of the data is stored in encrypted format.

The following query returns all objects contained in user mode:

SQL> SELECT object_name, object_type FROM user_objects;

The various tables in USER_view are as follows:

table describes

USER_TABLES contains information about the names, number of columns, and other details of all tables

USER_CATALOG contains tables, views, and synonyms

USER_COL_COMMENTS Contains comments for columns

USER_CONSTRAINTS Contains constraint definitions for tables

USER_INDEXES contains all information about the index created for the table (IND

USER_OBJECTS Contains all database objects owned by the user

USER_TAB_COLUMNS Contains columns and views of user-owned tables

USER_TAB_COMMENTS Contains comments for tables and views

USER_TRIGGERS Contains all user-defined triggers

USER_USERS stores information about the current user

Tables in USER_view

Example 1 demonstrates the use of the USER_TABLES view.

SQL> SELECT table_name,tablespace_name,dependencies from user_tables where table_name like 'D%';

This example displays detailed information about a table created by a user.

Example 2 demonstrates the use of the USER_INDEXES view.

SQL> SELECT index_name , table_name from user_indexes where index_name like 'H%';

This example shows index names and table names starting with "H" in USER_INDEXES.

Example 3 demonstrates the use of the USER_TRIGGER view.

SQL> SELECT trigger_name , trigger_type from user_triggers;

This example shows trigger names and types in the USER_TRIGGERS view.

Example 4 demonstrates the use of the USER_OBJECTS view.

SQL> SELECT object_name from user_objects where object_name like 'A%';

This example displays object names that begin with "A" in USER_OBJECT view.

About how to use user_view in Oracle to share here, I hope the above content can be of some help to everyone, you can learn more knowledge. If you think the article is good, you can share it so that more people can see it.

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.