Jerryme Joseph
Professor Kmir
Week 5 Assignment
Date: 12.02.2013

1) Create table CATEGORY(CatCode char(2),CatDes char(10)); | Table CATEGORY created. | Desc category | Name Null Type | CATCODE CHAR(2) | CATDES CHAR(10) |

2) Create table EMPLOYEES(Emp# number(5,2),Lastname varchar2(15),Firstname varchar2(15),Job_class varchar2(4));

Table EMPLOYEES created. | Desc employees | EMP# NUMBER(5,2) | LASTNAME VARCHAR2(15) | FIRSTNAME VARCHAR2(15) | JOB_CLASS VARCHAR2(4) | Name Null Type | 3) Alter table employees add (EmpDate date default sysdate,EndDate date);

Table EMPLOYEES altered. | Desc employees | Name Null Type | EMP# NUMBER(5,2) | LASTNAME VARCHAR2(15) | FIRSTNAME VARCHAR2(15) | JOB_CLASS VARCHAR2(4) | EMPDATE DATE | ENDDATE DATE | 4) Alter table employees
Modify(Job_class varchar2(2));

Desc JL_emps Name Null Type | --------- ---- ------------ | EMP# NUMBER(5,2) | LASTNAME VARCHAR2(15) | FIRSTNAME VARCHAR2(15) | JOB_CLASS VARCHAR2(2) | EMPDATE DATE |

5) Alter table employees
Drop column EndDate;

Table BOOK_PRICING created.

Desc BOOK_PRICING Name Null Type | -------- ---- ------------ | ID VARCHAR2(10) | COST NUMBER(5,2) | RETAIL NUMBER(5,2) | CATEGORY VARCHAR2(12) |

6) Rename employees to JL_EMPS;

Table EMPLOYEES altered.
Employees TO succeeded.
Desc jl_emps Name Null Type | --------- ---- ------------ | EMP# NUMBER(5,2) | LASTNAME VARCHAR2(15) | FIRSTNAME