COLUMN_NAME |
DATA_TYPE |
NULLABLE |
DATA_DEFAULT |
COLUMN_ID |
COMMENTS |
INSERTABLE |
UPDATABLE |
DELETABLE |
EMPLOYEE_ID |
NUMBER(6) |
No |
null |
1 |
null |
NO |
NO |
NO |
JOB_ID |
VARCHAR2(10) |
No |
null |
2 |
null |
NO |
NO |
NO |
MANAGER_ID |
NUMBER(6) |
Yes |
null |
3 |
null |
NO |
NO |
NO |
DEPARTMENT_ID |
NUMBER(4) |
Yes |
null |
4 |
null |
NO |
NO |
NO |
LOCATION_ID |
NUMBER(4) |
Yes |
null |
5 |
null |
NO |
NO |
NO |
COUNTRY_ID |
CHAR(2) |
Yes |
null |
6 |
null |
NO |
NO |
NO |
FIRST_NAME |
VARCHAR2(20) |
Yes |
null |
7 |
null |
NO |
NO |
NO |
LAST_NAME |
VARCHAR2(25) |
No |
null |
8 |
null |
NO |
NO |
NO |
SALARY |
NUMBER(8,2) |
Yes |
null |
9 |
null |
NO |
NO |
NO |
COMMISSION_PCT |
NUMBER(2,2) |
Yes |
null |
10 |
null |
NO |
NO |
NO |
DEPARTMENT_NAME |
VARCHAR2(30) |
No |
null |
11 |
null |
NO |
NO |
NO |
JOB_TITLE |
VARCHAR2(35) |
No |
null |
12 |
null |
NO |
NO |
NO |
CITY |
VARCHAR2(30) |
No |
null |
13 |
null |
NO |
NO |
NO |
STATE_PROVINCE |
VARCHAR2(25) |
Yes |
null |
14 |
null |
NO |
NO |
NO |
COUNTRY_NAME |
VARCHAR2(40) |
Yes |
null |
15 |
null |
NO |
NO |
NO |
REGION_NAME |
VARCHAR2(25) |
Yes |
null |
16 |
null |
NO |
NO |
NO |