Columns

Constraints

Grants

Statistics

Triggers

Dependencies

Details

Partitions

Indexes


COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID COMMENTS
EMPLOYEE_ID NUMBER(6,0) No null 1 Primary key of employees table.
FIRST_NAME VARCHAR2(20 BYTE) Yes null 2 First name of the employee. A not null column.
LAST_NAME VARCHAR2(25 BYTE) No null 3 Last name of the employee. A not null column.
EMAIL VARCHAR2(25 BYTE) No null 4 Email id of the employee
PHONE_NUMBER VARCHAR2(20 BYTE) Yes null 5 Phone number of the employee; includes country code and area code
HIRE_DATE DATE No null 6 Date when the employee started on this job. A not null column.
JOB_ID VARCHAR2(10 BYTE) No null 7 Current job of the employee; foreign key to job_id column of the jobs table. A not null column.
SALARY NUMBER(8,2) Yes 50000  8 Monthly salary of the employee. Must be greater than zero (enforced by constraint emp_salary_min)
COMMISSION_PCT NUMBER(2,2) Yes null 9 Commission percentage of the employee; Only employees in sales department elgible for commission percentage
MANAGER_ID NUMBER(6,0) Yes null 10 Manager id of the employee; has same domain as manager_id in departments table. Foreign key to employee_id column of employees table. (useful for reflexive joins and CONNECT BY query)
DEPARTMENT_ID NUMBER(4,0) Yes null 11 Department id where employee works; foreign key to department_id column of the departments table
CONSTRAINT_NAME CONSTRAINT_TYPE SEARCH_CONDITION R_OWNER R_TABLE_NAME R_CONSTRAINT_NAME DELETE_RULE STATUS DEFERRABLE VALIDATED GENERATED BAD RELY LAST_CHANGE INDEX_OWNER INDEX_NAME INVALID VIEW_RELATED
EMP_DEPT_FK Foreign_Key null HR DEPARTMENTS DEPT_ID_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 2011/08/28 null null null null
EMP_EMAIL_NN Check "EMAIL" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 2011/08/28 null null null null
EMP_EMAIL_UK Unique null null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 2011/08/28 null EMP_EMAIL_UK null null
EMP_EMP_ID_PK Primary_Key null null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 2011/08/28 null EMP_EMP_ID_PK null null
EMP_HIRE_DATE_NN Check "HIRE_DATE" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 2011/08/28 null null null null
EMP_JOB_FK Foreign_Key null HR JOBS JOB_ID_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 2011/08/28 null null null null
EMP_JOB_NN Check "JOB_ID" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 2011/08/28 null null null null
EMP_LAST_NAME_NN Check "LAST_NAME" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 2011/08/28 null null null null
EMP_MANAGER_FK Foreign_Key null HR EMPLOYEES EMP_EMP_ID_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 2011/08/28 null null null null
EMP_SALARY_MIN Check salary > 0 null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 2011/08/28 null null null null


Columns


COLUMN_NAME COLUMN_POSITION
DEPARTMENT_ID 1
COLUMN_NAME COLUMN_POSITION
EMAIL null
COLUMN_NAME COLUMN_POSITION
EMAIL 1
COLUMN_NAME COLUMN_POSITION
EMPLOYEE_ID 1
COLUMN_NAME COLUMN_POSITION
HIRE_DATE null
COLUMN_NAME COLUMN_POSITION
JOB_ID 1
COLUMN_NAME COLUMN_POSITION
JOB_ID null
COLUMN_NAME COLUMN_POSITION
LAST_NAME null
COLUMN_NAME COLUMN_POSITION
MANAGER_ID 1
COLUMN_NAME COLUMN_POSITION
SALARY null
PRIVILEGE GRANTEE GRANTABLE GRANTOR OBJECT_NAME
NAME VALUE
NUM_ROWS 107
BLOCKS 5
AVG_ROW_LEN 69
SAMPLE_SIZE 107
LAST_ANALYZED 2016/09/23
LAST_ANALYZED_SINCE 2016/09/23


Column Statistics


TRIGGER_NAME TRIGGER_TYPE TRIGGER_OWNER TRIGGERING_EVENT STATUS TABLE_NAME
SECURE_EMPLOYEES BEFORE STATEMENT HR INSERT OR UPDATE OR DELETE DISABLED EMPLOYEES
UPDATE_JOB_HISTORY AFTER EACH ROW HR UPDATE ENABLED EMPLOYEES 



TRIGGER secure_employees
  BEFORE INSERT OR UPDATE OR DELETE ON employees
BEGIN
  secure_dml;
END secure_employees;
TRIGGER update_job_history
  AFTER UPDATE OF job_id, department_id ON employees
  FOR EACH ROW
BEGIN
  add_job_history(:old.employee_id, :old.hire_date, sysdate,
                  :old.job_id, :old.department_id);
END;
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
HR SECURE_EMPLOYEES TRIGGER HR EMPLOYEES TABLE
HR EMP_DETAILS_VIEW VIEW HR EMPLOYEES TABLE
HR UPDATE_JOB_HISTORY TRIGGER HR EMPLOYEES TABLE


References


OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
NAME VALUE
CREATED 2011/08/28
LAST_DDL_TIME 2016/10/03
OWNER HR
TABLE_NAME EMPLOYEES
TABLESPACE_NAME USERS
CLUSTER_NAME null
IOT_NAME null
STATUS VALID
PCT_FREE 10
PCT_USED null
INI_TRANS 1
MAX_TRANS 255
INITIAL_EXTENT 65536
NEXT_EXTENT 1048576
MIN_EXTENTS 1
MAX_EXTENTS 2147483645
PCT_INCREASE null
FREELISTS null
FREELIST_GROUPS null
LOGGING YES
BACKED_UP N
NUM_ROWS 107
BLOCKS 5
EMPTY_BLOCKS 0
AVG_SPACE 0
CHAIN_CNT 0
AVG_ROW_LEN 69
AVG_SPACE_FREELIST_BLOCKS 0
NUM_FREELIST_BLOCKS 0
DEGREE 1
INSTANCES 1
CACHE N
TABLE_LOCK ENABLED
SAMPLE_SIZE 107
LAST_ANALYZED 2016/09/23
PARTITIONED NO
IOT_TYPE null
OBJECT_ID_TYPE null
TABLE_TYPE_OWNER null
TABLE_TYPE null
TEMPORARY N
SECONDARY N
NESTED NO
BUFFER_POOL DEFAULT
ROW_MOVEMENT DISABLED
GLOBAL_STATS YES
USER_STATS NO
DURATION null
SKIP_CORRUPT DISABLED
MONITORING YES
CLUSTER_OWNER null
DEPENDENCIES DISABLED
COMPRESSION DISABLED
COMPRESS_FOR null
DROPPED NO
COMMENTS employees table. Contains 107 rows. References with departments, jobs, job_history tables. Contains a self reference.
PARTITION_NAME LAST_ANALYZED NUM_ROWS BLOCKS SAMPLE_SIZE HIGH_VALUE



INDEX_OWNER INDEX_NAME UNIQUENESS STATUS INDEX_TYPE TEMPORARY PARTITIONED FUNCIDX_STATUS JOIN_INDEX COLUMNS COLUMN_EXPRESSION
HR EMP_JOB_IX NONUNIQUE VALID NORMAL N NO null NO JOB_ID null
HR EMP_NAME_IX NONUNIQUE VALID NORMAL N NO null NO LAST_NAME, FIRST_NAME null
HR EMP_EMAIL_UK UNIQUE VALID NORMAL N NO null NO EMAIL null
HR EMP_EMP_ID_PK UNIQUE VALID NORMAL N NO null NO EMPLOYEE_ID null
HR EMP_MANAGER_IX NONUNIQUE VALID NORMAL N NO null NO MANAGER_ID null
HR EMP_DEPARTMENT_IX NONUNIQUE VALID NORMAL N NO null NO DEPARTMENT_ID null



INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
HR EMP_JOB_IX HR EMPLOYEES JOB_ID 1 10 10 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
HR EMP_NAME_IX HR EMPLOYEES LAST_NAME 1 25 25 ASC
HR EMP_NAME_IX HR EMPLOYEES FIRST_NAME 2 20 20 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
HR EMP_EMAIL_UK HR EMPLOYEES EMAIL 1 25 25 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
HR EMP_EMP_ID_PK HR EMPLOYEES EMPLOYEE_ID 1 22 0 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
HR EMP_MANAGER_IX HR EMPLOYEES MANAGER_ID 1 22 0 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
HR EMP_DEPARTMENT_IX HR EMPLOYEES DEPARTMENT_ID 1 22 0 ASC