Re: How make data transfomation faster?

From: sim <jmenker_at_muenster.de>
Date: 1 Feb 2006 06:30:48 -0800
Message-ID: <1138804248.754630.317200@g44g2000cwa.googlegroups.com>

You could use something like this:

SELECT USER_ID,

	   MAX(DECODE(KIND,1,DATE_TIME,NULL)) START_DATE,
	   MAX(DECODE(KIND,2,DATE_TIME,NULL)) FINISH_DATE

FROM LOG
WHERE KIND IN (1,2)
GROUP BY USER_ID If you want to store the results in a separate table put a 'create table as' in front of the SQL statement.

sim Received on Wed Feb 01 2006 - 08:30:48 CST