常用 索引 约束 查询--格式不变(插入代码-->SQL)

SQL> select INDEX_NAME,INDEX_TYPE,TABLE_NAME,TABLE_TYPE,UNIQUENESS from user_indexes;INDEX_NAME     INDEX_TYPE   TABLE_NAME       TABLE_TYPE  UNIQUENES-------------------- -------------------- -------------------- ----------- ---------PK_DEPT      NORMAL  DEPT       TABLE   UNIQUEPK_EMP     NORMAL  EMP       TABLE   UNIQUEIDX_EMP_CP_EMPNO     NORMAL  EMP_CP       TABLE   UNIQUESYS_IL0000011316C000 LOB  PLAN_TABLE       TABLE   UNIQUE36$$IDX_SKIP_IDX_EMP     NORMAL  SKIP_IDX_EMP       TABLE   NONUNIQUEIDX_EMP_MGR     NORMAL  EMP_EXECPLAN       TABLE   NONUNIQUEIDX_DEPTNO     NORMAL  EMP_TEMP       TABLE   NONUNIQUEIDX_MGR      NORMAL  EMP_TEMP       TABLE   NONUNIQUE8 rows selected.

SQL> select cu.CONSTRAINT_NAME,au.CONSTRAINT_type, au.INDEX_NAME,au.TABLE_NAME,cu.COLUMN_NAME from user_cons_columns cu, user_constraints au where cu.constraint_name = au.constraint_name ;CONSTRAINT_NAME        C INDEX_NAME      TABLE_NAME   COLUMN_NAME------------------------------ - -------------------- -------------------- --------------------PK_DEPT        P PK_DEPT      DEPT   DEPTNOPK_EMP       P PK_EMP       EMP   EMPNOFK_DEPTNO       R      EMP   DEPTNOSYS_C003264       C      EMP_CP   EMPNOSYS_C003225       C      EMP_CP   MGRSYS_C003263       C      DEPT_CP   DEPTNOSYS_C003256       C      DEPT_CP   DNAMESYS_C003022       C      TEST_TRANS_DOWN   TNAMESYS_C003224       C      EMP_EXECPLAN   MGRSYS_C003247       C      EMP_TEMP   ENAMESYS_C003249       C      SKIP_IDX_EMP   EMP_IDCONSTRAINT_NAME        C INDEX_NAME      TABLE_NAME   COLUMN_NAME------------------------------ - -------------------- -------------------- --------------------SYS_C003253       C      EMP_T   EMPNOSYS_C003254       C      EMP_T   ENAMESYS_C003255       C      EMP_T   MGR14 rows selected.SQL>