Table Creation

Q: 1
Create a table Employee with fields
EmpNo         Number (6)          Primary key
Name          Character (25)
Designation   Character (20)
Department    Character (25)
BasicPay      Number (8, 2)
DA            Number (8, 2)
Total         Number (8, 2)


SQL> CREATE TABLE EMPLOYEE(
  2  EMPNO NUMBER(6) PRIMARY KEY,
  3  NAME CHARACTER(25),
  4  DESIGNATION CHARACTER(20),
  5  DEPARTMENT CHARACTER(25),
  6  BASICPAY NUMBER(8,2),
  7  DA NUMBER(8,2),
  8  TOTAL NUMBER(8,2));

Table created.