create table empl(
id number(10) primary key,
ename varchar2(20) not null,
gender char(1),
age number(2) check (age>20 and age<60),
salary decimal(7,2),
doj date
);
desc empl;
insert into empl values(2,'Aritra Ghosh', 'M', 21, 99999.99, to_Date('12-dec-2022','DD-MM-YYYY'));
insert into empl values(4,'abc', 'F', 21, 99999.99, to_Date('12-12-2026','DD-MM-YYYY'));
insert into empl values(5,'def', 'M', 59, 999.89, to_Date('12-12-2026','DD-MM-YYYY'));
insert into empl values(06,'ghi', 'F', 50, 100.00, to_Date('2026-12-12','YYYY-MM-DD'));
insert into empl values(7,'def', 'M', 59, 999.89, to_Date('2026-12-12','YYYY-MM-DD'));
insert into empl values(9,'xyz', 'F', 59, 9.09, to_Date('01-01-2026','DD-MM-YYYY'));
Select * from empl;
Truncate table empl;
select id, ename, salary from empl where salary>01.00 and salary<200.00;