A reader, January 10, 2020 - 5:05 am UTC
Dear Sir,
TASKID | EMPLOYEECODE| SLOT_ACTION | date
1 | A | S | 08/jan/2020 09:30:32 am
1 | A | p | 08/jan/2020 02:10:20 pm
1 | A | S | 09/jan/2020 09:50:50 am
1 | A | P | 09/jan/2020 12/50:58 pm
1 | A | S | 10/jan/2020 09:30:32 am
1 | A | P | 10/jan/2020 12/50:58 pm
1 | A | S | 11/jan/2020 09:30:32 am
1 | A | p | 11/jan/2020 02:10:20 pm
1 | A | S | 12/jan/2020 09:50:50 am
1 | A | P | 12/jan/2020 12/50:58 pm
1 | A | S | 13/jan/2020 09:30:32 am
1 | A | P | 13/jan/2020 12/50:58 pm
1 | A | S | 14/jan/2020 09:30:32 am
1 | A | p | 14/jan/2020 02:10:20 pm
1 | A | S | 15/jan/2020 09:50:50 am
1 | A | P | 15/jan/2020 12/50:58 pm
1 | A | S | 16/jan/2020 09:30:32 am
1 | A | P | 16/jan/2020 12/50:58 pm
1 | A | S | 17/jan/2020 09:30:32 am
1 | A | p | 17/jan/2020 02:10:20 pm
1 | A | S | 18/jan/2020 09:50:50 am
1 | A | P | 18/jan/2020 12/50:58 pm
1 | A | S | 19/jan/2020 09:30:32 am
1 | A | P | 19/jan/2020 12/50:58 pm
. . . .
. . . .
like that 100 records there
2nd last and last record is
1 A S 10/feb/2020 09:30:58 am
1 A E 10/feb/2020 05:20:25 pm
they want calculate time.
they ask how much time taken to complete taskid 1 for employee A?
Where
S - Start work
P - Pause work
E - End or completed work.
1 - Taskid
A - EMPLOYEECODE
they want output like this
TASKID | EMPLOYEECODE| total_taken_hours
1 A 100hours
January 10, 2020 - 9:47 am UTC
Spamming us with the same question over and over is one of the best ways to guarantee we WON'T answer it!
Latest version installation worked
Pavan, June 23, 2020 - 12:35 pm UTC
Hi Tom,
Thanks for your input.
I have downloaded the latest Oracle SQL Developer version 19.4.While installing I have selected my previous version. Hence without hassle, it has migrated my previous users and data as well.
Regards,
Pavan
June 26, 2020 - 4:13 am UTC
Glad we could help