alter table employee add(PF decimal(7,2), netsalary decimal(7,2),
grosssalary decimal(7,2));
Table altered.
|
Name
|
Null?
|
Type
|
|
E_NO
|
|
CHAR(10)
|
|
E_NAME
|
NOT NULL
|
VARCHAR2(20)
|
|
BDATE
|
|
DATE
|
|
TRA
|
|
NUMBER(7,2)
|
|
DA
|
|
NUMBER(7,2)
|
|
SALARY
|
|
NUMBER(10,2)
|
|
D_NO
|
NOT NULL
|
NUMBER(38)
|
|
SSN
|
NOT NULL
|
CHAR(5)
|
|
PF
|
|
NUMBER(7,2)
|
|
NETSALARY
|
|
NUMBER(7,2)
|
|
GROSSSALARY
|
|
NUMBER(7,2)
|
No comments:
Post a Comment