PDA

View Full Version : Oracle Programming: Create table Dept and Emp with the following Constraints



srrinivas
06-10-2011, 06:24 PM
1) Create table Dept and Emp with the following Constraints
Dept Emp
Field Name Date Type Field Name Data Type
Deptno Number2(2) Empno Number(4)
Dname Varchar2(8) Ename Varchar2(30)
Location Varchar2(15) Job Varchar2(10)
DOJ Date
Sal Number(8,2)
Comm Number(3)
Deptno Number(2)