Attention: To align with new corporate security policies, and to match policies adopted by other communities within Oracle, the My Oracle Support Community access requirements will change beginning September 18, 2025. MOSC will now require that member accounts in our community be associated to a *corporate* email address. This means that users with generic domains (such as gmail.com, yahoo.com, and others) will no longer be granted access to the discussion forums and ideas labs. If this policy affects you, act now to change the email address that is associated with your Oracle (and community) account. Alternatively, you can opt to create a new Oracle account that uses your corporate email domain.

SQL Language (MOSC)

Best approach to slove this problem

Oct 15, 2014 9:57AM edited Oct 16, 2014 8:39AM in SQL Language (MOSC) 4 commentsAnswered ✓

Hello,

i have a log table with fields which contains start and end of a process. To explain here is a small example:

TSTAMP	DISPOJRNNR	ACTION	DOKART	DOKNR
15.10.2014 15:13:00.402000	28974308	U	PA	70358598
15.10.2014 15:13:00.402000	28974306	U	PA	70358598
15.10.2014 15:13:00.402000	28974307	U	PA	70358598
15.10.2014 15:13:05.480000	28974313	U	PA	70358600
15.10.2014 15:13:05.480000	28974312	U	PA	70358600
15.10.2014 15:13:05.480000	28974314	U	PA	70358600
15.10.2014 15:13:09.323000	28987183	I	AB	10677866
15.10.2014 15:13:09.323000	28987182	I	AB	10677866
15.10.2014 15:13:10.573000	28974198	U	PA	70358562
15.10.2014 15:13:10.589000	28974199	U	PA	70358562
15.10.2014 15:13:10.589000	28974197	U	PA	70358562
15.10.2014 15:13:15.792000	28974361	U	PA	70358616
15.10.2014 15:13:15.807000	28974360	U	PA	70358616
15.10.2014 15:13:15.807000	28974362	U	PA	70358616
15.10.2014 15:13:23.010000	28987183	U	AB	10677866
15.10.2014 15:13:23.026000	28987182	U	AB	10677866
15.10.2014 15:13:55.415000	28987170	D	AB	10677710
15.10.2014 15:13:55.478000	28987184	I	AB	10677710
15.10.2014 15:13:55.509000	28987185	I	AB	10677710
15.10.2014 15:13:55.556000	28987186	I	AB	10677710
15.10.2014 15:13:55.603000	28987187	I	AB	10677710
15.10.2014 15:13:55.618000	28987188	I	AB	10677710
15.10.2014 15:13:55.649000	28987189	I	AB	10677710
15.10.2014 15:14:13.493000 (starts here)	28987171	U	BS	10033686
15.10.2014 15:14:13.508000 (....)	28987173	U	BS	10033686
15.10.2014 15:14:13.508000 (interrupted/disconnected)	28987172	U	AB	10055987
15.10.2014 15:14:13.524000 (ends here)	28987174	U	BS	10033686
15.10.2014 15:14:24.539000	28984575	U	AB	10675867
15.10.2014 15:14:24.976000	28983752	U	AB	10677690
15.10.2014 15:14:25.305000	28983990	U	AB	10677701

I want to find cases where a process (DOKART/DOKNR)

0

Howdy, Stranger!

To view full details, sign in to My Oracle Support Community.

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month