Common statements for querying ORACLE system tables

This article mainly explains the "ORACLE system table query commonly used sentences", the article explains the content is simple and clear, easy to learn and understand, the following please follow the editor's ideas slowly in depth, together to study and learn "ORACLE system table query commonly used sentences" bar!

Query the index under the partition

Select * from user_objects

/ * get the table: * / select table_name from user_tables;-- current user's table select table_name from all_tables;-- all users' tables select table_name from dba_tables;-- including system tables-- Table field information select * from all_tab_columns a where a.TABLENAME names. -- Table field annotation information select * from user_col_comments a where a.tableroomnameplate Tunable X27 partition and a.table_name=upper information-- Table partition information-- 1, partition table information-- (1) display information of all database partition tables select * partition a where a.owner=upper ('') and a.table_name=upper ('') -- (2) display all partition table information accessible to the current user select * from ALL_PART_TABLES a where a.owner=upper ('') and a.table_name=upper ('');-- (3) display the information of all current user partition tables select * from USER_PART_TABLES a where a.table_name=upper ('') -- 2, the partition column information of the partition table-- (1) displays the partition column information of all partition tables of the current user select * from USER_PART_KEY_COLUMNS a where a.name=upper ('') and a.objectpartition typepercent partition column information select * partition a where a.owner=upper ('etl') and a.name=upper ('') and a.objectpartition type tables accessible to the current user. -- (3) the partition column shows the partition column information of all database partition tables select * from DBA_PART_KEY_COLUMNS a where a.owner=upper ('etl') and a.name=upper ('') and a.objectpartition type tables belonging to TABLEX where a.table_name=upper-3, the name of the partition table, the belonging table space and the details of the partition of the table select * partition a where a.table_name=upper ('') -- 4. View the sub-partition information and sub-partition column information of the combined table-- (1) display the sub-partition information of all the combined partition tables of the current user select * from USER_TAB_SUBPARTITIONS;-- (2) display the sub-partition information of all the combined partition tables that the current user can access select * from ALL_TAB_SUBPARTITIONS -- (3) display the sub-partition information of all combined partition tables accessible to the current user select * from ALL_TAB_SUBPARTITIONS;-- (4) display the sub-partition column information of all current user-accessible partition tables select * from USER_SUBPART_KEY_COLUMNS;-- (5) display the sub-partition column information select * from ALL_SUBPART_KEY_COLUMNS of all partition tables that the current user can access. -- (6) display the sub-partition column shows the sub-partition column information of all the partition tables in the database select * the index select * from user_indexes where table_name=upper ('Tunable X27 user') contained in the from DBA_SUBPART_KEY_COLUMNS;-- table;-- specific information of the index: view the fields contained in the index select * from user_ind_columns where index_name = 'UK_T_X27_USER_USERID' according to the index name. -- unique constraint of the table select * from user_constraints where constraint_type='U' and owner='ETL' and table_name='T_X27_USER';-- external key select * from user_constraints where constraint_type='R' and owner='ETL' and table_name='T_X27_USER';-- external key and constraint field composition information select * from user_cons_columns where owner='ETL' and table_name='T_X27_USER' Thank you for your reading, the above is the content of "ORACLE system table query commonly used sentences", after the study of this article, I believe you have a deeper understanding of the problem of ORACLE system table query commonly used sentences, the specific use of the situation also needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!