SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How can i Calculate time of employees for attendance?

Poor-BoyAug 18 2016 — edited Aug 27 2016

Hi experts, plz Guide me my requirment is i need need to save employees in and Out time into database for attendance...

I am thinking about this Script ... is it looks good or need to improvment?

Create table Attendance (Employee_id number(10),Employee_name varchar2(25),Dept_id number(10),in_time Date,Out_time date,Flag varchar2(20),total_hourse date);

and also tell me how can i take his In_time and out time?

This post has been answered by HolgerH on Aug 18 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 24 2016

Added on Aug 18 2016

20 comments

3,102 views