Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

Combine user_constraints and user_cons_columns

SQL> SQL> select  a.constraint_type || a.constraint_name as csort,   2      decode(a.constraint_type,'P','Primary Key','R','Foreign Key','C','Check','Other') as ctype,   3      a.table_name || '.' || a.constraint_name as cname,   4      b.position as cpos,   5      b.column_name as colname,   6      a.search_condition as crule,   7      a.r_constraint_name as crefer   8    from user_constraints a, user_cons_columns b   9   where a.constraint_name = b.constraint_name and rownum < 50  10   order by csort, b.position  11  / CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ CBIN$7jo86iFsTs26s2bB3k3wxA==$0 Check BIN$z+/2/T9WTRWmOfXZhvGBPQ==$0.BIN$7jo86iFsTs26s2bB3k3wxA==$0 WORKER_ID CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ "WORKER_ID" IS NOT NULL CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ CBIN$AG2pRJeXSS2fZBgGOwm+Zw==$0 Check BIN$BIALfQCESHa/SipQl+oqGg==$0.BIN$AG2pRJeXSS2fZBgGOwm+Zw==$0 ID CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ "ID" IS NOT NULL CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ CBIN$Hp7fY/C7QHuGuuejsVe0Kg==$0 Check BIN$BIALfQCESHa/SipQl+oqGg==$0.BIN$Hp7fY/C7QHuGuuejsVe0Kg==$0 LOGICAL_WORKPLACE_ID CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ "LOGICAL_WORKPLACE_ID" IS NOT NULL CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ CBIN$LK1awudKQBShT/ikiTUW+Q==$0 Check BIN$uR9LzoavTbyjK4b4t8kgXg==$0.BIN$LK1awudKQBShT/ikiTUW+Q==$0 ACTIVE_DATE CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ "ACTIVE_DATE" IS NOT NULL CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ CBIN$Q858xZXjRjaShEoGqYOlpg==$0 Check BIN$z+/2/T9WTRWmOfXZhvGBPQ==$0.BIN$Q858xZXjRjaShEoGqYOlpg==$0 ID CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ "ID" IS NOT NULL CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ CBIN$QgU3IiZvTlSc5soFs0Yprg==$0 Check BIN$ukEn3nqRT+u/paBe8fJpxQ==$0.BIN$QgU3IiZvTlSc5soFs0Yprg==$0 ACTIVE_DATE CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ "ACTIVE_DATE" IS NOT NULL CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ CBIN$hCmUWcCnTVedz74x69dwOw==$0 Check BIN$z+/2/T9WTRWmOfXZhvGBPQ==$0.BIN$hCmUWcCnTVedz74x69dwOw==$0 ACTIVE_DATE CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ "ACTIVE_DATE" IS NOT NULL CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ CBIN$hdsDtlRrQyiRZwUDoifzYQ==$0 Check BIN$BIALfQCESHa/SipQl+oqGg==$0.BIN$hdsDtlRrQyiRZwUDoifzYQ==$0 WORKER_ID CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ "WORKER_ID" IS NOT NULL CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ CBIN$ipIeQQ+8SWqoL5m5AZhtYw==$0 Check BIN$ukEn3nqRT+u/paBe8fJpxQ==$0.BIN$ipIeQQ+8SWqoL5m5AZhtYw==$0 WORKER_ID CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ "WORKER_ID" IS NOT NULL CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ CBIN$ixWMQi5sQuS6TWePjKts3g==$0 Check BIN$2AYTRnCPRfG80DYlHN4sJg==$0.BIN$ixWMQi5sQuS6TWePjKts3g==$0 ACTIVE_DATE CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ "ACTIVE_DATE" IS NOT NULL CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ CBIN$jSDpAUgDR0yEtuw4gblNiQ==$0 Check BIN$ukEn3nqRT+u/paBe8fJpxQ==$0.BIN$jSDpAUgDR0yEtuw4gblNiQ==$0 LOGICAL_WORKPLACE_ID CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ "LOGICAL_WORKPLACE_ID" IS NOT NULL CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ CBIN$lYdZT3sESH+sFgqJRWiwMg==$0 Check BIN$2AYTRnCPRfG80DYlHN4sJg==$0.BIN$lYdZT3sESH+sFgqJRWiwMg==$0 ID CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ "ID" IS NOT NULL CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ CBIN$p/qwfEmtQh2uY1VCYeutOw==$0 Check BIN$z+/2/T9WTRWmOfXZhvGBPQ==$0.BIN$p/qwfEmtQh2uY1VCYeutOw==$0 LOGICAL_WORKPLACE_ID CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ "LOGICAL_WORKPLACE_ID" IS NOT NULL CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ CBIN$pqYsOQBsTlimA1sF/4BrgA==$0 Check BIN$2AYTRnCPRfG80DYlHN4sJg==$0.BIN$pqYsOQBsTlimA1sF/4BrgA==$0 WORKER_ID CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ "WORKER_ID" IS NOT NULL CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ CBIN$t8GSYvQHRI6Fjqp5uEhUBQ==$0 Check BIN$2AYTRnCPRfG80DYlHN4sJg==$0.BIN$t8GSYvQHRI6Fjqp5uEhUBQ==$0 LOGICAL_WORKPLACE_ID CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ "LOGICAL_WORKPLACE_ID" IS NOT NULL CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ CBIN$ucRob1YtSGaFOl8RzJnysA==$0 Check BIN$ukEn3nqRT+u/paBe8fJpxQ==$0.BIN$ucRob1YtSGaFOl8RzJnysA==$0 ID CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ "ID" IS NOT NULL CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ CBIN$x7NqoC+WQyKj/Ckt/sDBlQ==$0 Check BIN$BIALfQCESHa/SipQl+oqGg==$0.BIN$x7NqoC+WQyKj/Ckt/sDBlQ==$0 ACTIVE_DATE CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ "ACTIVE_DATE" IS NOT NULL CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ CSYS_C004378                    Check DDL_AUDIT.SYS_C004378 OBJECT_NAME CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ "OBJECT_NAME" IS NOT NULL CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ CSYS_C004379                    Check DDL_AUDIT.SYS_C004379 OBJECT_TYPE CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ "OBJECT_TYPE" IS NOT NULL CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ CSYS_C004380                    Check DDL_AUDIT.SYS_C004380 WHEN_CREATED CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ "WHEN_CREATED" IS NOT NULL CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ CSYS_C004381                    Check DDL_AUDIT.SYS_C004381 WHO_CREATED CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ "WHO_CREATED" IS NOT NULL CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ CSYS_C004441                    Check SITE_TAB.SYS_C004441 SITE_NO CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ "SITE_NO" IS NOT NULL CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ CSYS_C004442                    Check SITE_TAB.SYS_C004442 SITE_DESCR CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ "SITE_DESCR" IS NOT NULL CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ CSYS_C004617                    Check HAZARD_LEVEL_T.SYS_C004617 ID CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ "ID" IS NOT NULL CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ CSYS_C004618                    Check HAZARD_LEVEL_T.SYS_C004618 MAGNITUDE CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ "MAGNITUDE" IS NOT NULL CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ CSYS_C004619                    Check HAZARD_LEVEL_T.SYS_C004619 CODE CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ "CODE" IS NOT NULL CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ CSYS_C004620                    Check HAZARD_LEVEL_T.SYS_C004620 DESCRIPTION CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ "DESCRIPTION" IS NOT NULL CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ CSYS_C004621                    Check HAZARD_LEVEL_T.SYS_C004621 ACTIVE_DATE CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ "ACTIVE_DATE" IS NOT NULL CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ CSYS_C006545                    Check WORKING_CUSTOMERS.SYS_C006545 LASTNAME CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ "LASTNAME" IS NOT NULL CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ CSYS_C006546                    Check WORKING_CUSTOMERS.SYS_C006546 FIRSTNAME CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ "FIRSTNAME" IS NOT NULL CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ PAVAIL_TRACE_FILES_PK           Primary Key AVAIL_TRACE_FILES.AVAIL_TRACE_FILES_PK                                 1 USERNAME CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ PAVAIL_TRACE_FILES_PK           Primary Key AVAIL_TRACE_FILES.AVAIL_TRACE_FILES_PK                                 2 FILENAME CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ PBIN$m0vd5DhgSUeFjOSJ5z1H0Q==$0 Primary Key BIN$2AYTRnCPRfG80DYlHN4sJg==$0.BIN$m0vd5DhgSUeFjOSJ5z1H0Q==$0          1 ID CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ PEMPLOYEE_EVALUATION_PK         Primary Key EMPLOYEE_EVALUATION.EMPLOYEE_EVALUATION_PK                             1 ID CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ PEMPLOYEE_EVALUATION_PK         Primary Key EMPLOYEE_EVALUATION.EMPLOYEE_EVALUATION_PK                             2 TITLE CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ PSYS_C004533                    Primary Key HOME_ADDRESS_LIST.SYS_C004533                                          1 LIST_ID CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ PSYS_C006768                    Primary Key P.SYS_C006768                                                          1 X CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ PSYS_C007431                    Primary Key MYCLOB.SYS_C007431                                                     1 ID CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ PSYS_C007979                    Primary Key I1.SYS_C007979                                                         1 N CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ PSYS_C007980                    Primary Key I2.SYS_C007980                                                         1 N CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ PSYS_C007981                    Primary Key MAP.SYS_C007981                                                        1 N CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ RSYS_C007982                    Foreign Key MAP.SYS_C007982                                                        1 I1 CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ SYS_C007979 CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ RSYS_C007983                    Foreign Key MAP.SYS_C007983                                                        1 I2 CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ SYS_C007980 CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ UBIN$w7oUQV1JTnC+qkix9Qi1eQ==$0 Other BIN$z+/2/T9WTRWmOfXZhvGBPQ==$0.BIN$w7oUQV1JTnC+qkix9Qi1eQ==$0          1 WORKER_ID CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ UBIN$w7oUQV1JTnC+qkix9Qi1eQ==$0 Other BIN$z+/2/T9WTRWmOfXZhvGBPQ==$0.BIN$w7oUQV1JTnC+qkix9Qi1eQ==$0          2 ACTIVE_DATE CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ USYS_C004534                    Other HOME_ADDRESS_LIST.SYS_C004534                                          1 SYS_NC0000200003$ CSORT                           CTYPE ------------------------------- ----------- CNAME                                                               CPOS ------------------------------------------------------------- ---------- COLNAME -------------------------------------------------------------------------------- CRULE -------------------------------------------------------------------------------- CREFER ------------------------------ 46 rows selected. SQL>