System table corresponding to common ORACLE Objects

Common ORACLE Objects correspond to system tables to obtain the primary key of the data table select d. COLUMN_NAME FROMUSER_CONS_COLUMNS D, USER_CONSTRAINTS mwhere m. CONSTRAINT_NAME = D. CONSTRAINT_NAMEAND M. CONSTRAINT_TYPE = 'p' and m. TABLE_NAME = _ TableName the system tables/views used to store database tables mainly include: DBA_ALL_TABLES, which describes all objects in the database and related tables. ALL_ALL_TABLES describes all objects accessible to users in the database and related tables. USER_ALL_TABLES describes the objects owned by the current user in the database and related tables. Www.2cto.com DBA _ TABLES describes all relevant TABLES in the database. ALL _ TABLES describes the TABLES that ALL users in the database can access. USER _ TABLES describes the TABLES owned by the current USER in the database. The system table/view that stores the column attributes of database tables mainly includes: DBA_TAB_COLUMNS, which describes the column attributes of all tables in the database. ALL_TAB_COLUMNS describes the column attributes of all tables that can be accessed by users in the database. USER_TAB_COLUMNS describes the column attributes of the table owned by the current user in the database. ALL_TAB_COLS describes the column attributes of all tables that can be accessed by all users in the database. Obtain the stored procedure. The system tables/views of the stored system objects include DBA_OBJECTS, which describes all objects in the database. ALL_OBJECTS describes all the objects that can be accessed in the database. USER_OBJECTS describes all objects owned by the current user in the database. SYS_OBJECTS is used to obtain a view. The system tables/views of the database view mainly include: DBA_VIEWS describes the attributes of all views in the database. ALL_VIEWS describes the attributes of views accessible to all users in the database. USER_VIEWS describes the attributes of all current users in the database that have views. Obtain the trigger method to store the system table/view of the database trigger. DBA_TRIGGERS describes all the trigger attributes in the database. ALL _ TRIGGERS describes the attributes of TRIGGERS that ALL users in the database can access. USER _ TRIGGERS describes all the attributes of the trigger owned by the current USER in the database. Method for obtaining trigger content: SELECT TRIGGER_BODY from sys. ALL_TRIGGERS WHERE TRIGGER_NAME = 'xxx'; the indexing method is used to store the system tables/views of database indexes. DBA_INDEXES describes the attributes of all indexes in the database. ALL _ INDEXES describes the attributes of INDEXES accessible to ALL users in the database. USER _ INDEXES describes all the attributes of INDEXES owned by the current USER in the database. Method for obtaining index-related columns at www.2cto.com: SELECT COLUMN_NAME from sys. ALL_IND_COLUMNS WHERE INDEX_NAME = 'xxx' AND TABLE_OWNER = 'dbaudit '; system tables/views of database users stored mainly include: DBA_USERS describes all user attributes in the database. ALL_USERS describes all user attributes in the database. USER_USERS