Strives for the great god, employees sign in oracle triggers when the judge signed in the success of how to write and update to the sign in the table?
The checkin attendance is numbered tno check-in time (date) signed in state state
The determination standard is the time schedule of check-in time signintime varchar2 (types of) also points the morning afternoon
God help me,

CodePudding user response:

Program directly determine to go, take it as a transaction, end of the transaction is successful
Otherwise the failure
Don't need to use the trigger

CodePudding user response:

reference 1st floor sych888 response:

program directly determine to go, take it as a transaction, end of the transaction is successful
Otherwise the failure
Don't need to use the trigger

+ 1 can judge in the business,
PS: trigger it runs in the background, invisible, my principle, can not you don't have to

CodePudding user response:

This is the oracle's operating, must use oracle, I am a novice, had just begun to learn, there are a lot of don't know, don't think for a long time to come up with what to do, only in refer to the great god

CodePudding user response:

With a certain table, the trigger to
Workers sign in when the judge signed in success and update to the sign-in sheet, how to determine when check-in? What is a table, or sign in,

CodePudding user response:

The

refer to the original poster Sirius_No23 response:

The determination standard is the time schedule of check-in time signintime varchar2 (types of) also points the morning afternoon
The great god help me,

the judgement standard is what meaning, is signed in the checkin time less than the schedule time signintime sign in successfully?

 update sign in table t set tc heckin=sysdate, t.s Tate=1 where t.t no='