Hi Team
Can please help i have data with 1000 records like so_id & Date in that data need to remove Saturday and Sunday records using
sysdate
i.e please find the below DDL and DML script.
Create table revenue_t (
So_ID number,
So_Date Date
);
insert into table revenue_t values(1,'12-05-17'); --Sat
insert into table revenue_t values(1,'13-05-17'); --San
insert into table revenue_t values(1,'14-05-17');
insert into table revenue_t values(1,'15-05-17');
insert into table revenue_t values(1,'16-05-17');
insert into table revenue_t values(1,'17-05-17');
insert into table revenue_t values(1,'18-05-17');
insert into table revenue_t values(1,'19-05-17'); --Sat
insert into table revenue_t values(1,'20-05-17'); --San
insert into table revenue_t values(1,'21-05-17');
insert into table revenue_t values(1,'22-05-17');
Thanks in Advance