Tags » Jero

JERO interview on NBC Chicago on 1/14/2012

Jerome Charles White, Jr, better known by his stage name Jero is an enka singer of African-American and Japanese descent. He is the first black enka singer i…

oracle Time clock find exceptions with the given date range (orphan punches)

I have a table clockin date and clockout date.

__________________________________________
userid | clockin_date           | clockout_date
------------------------------------------
a1     | '15.SEP.2014 09:24:36' | '16.SEP.2014 06:24:36'
b1     | '15.SEP.2014 09:00:36' | '16.SEP.2014 05:24:36'
b1     | '16.SEP.2014 09:05:36' | '16.SEP.2014 09:54:36'
b1     | '16.SEP.2014 10:24:36' | '17.SEP.2014 06:00:06'
b1     | '18.SEP.2014 09:24:36' | '18.SEP.2014 05:00:00'
-----------------------
… 186 more words
Stackoverflow