Re: Rewrite into SQL

From: gokulkumar gopal <gokulkumar.gopal@xxxxxxxxx>
To: Oracle-L Group <oracle-l@xxxxxxxxxxxxx>
Date: Tue, 10 Mar 2009 22:17:21 +0100

 Hi Amonte,

Another sql way.

insert into backup_trace
select <column list>
from
(
select t.*,max(case when data_field = 'DELETE' then trace_seq else 0 end)
over (partition by cntr_no) maxsequence
from trace_inv
where update_time <= sysdate - 60
) where trace_seq <= maxsequence


HTH
Gokul

References:
- Rewrite into SQL
  - From: amonte
- Re: Rewrite into SQL
  - From: Toon Koppelaars
- Re: Rewrite into SQL
  - From: amonte
- Re: Rewrite into SQL
  - From: Toon Koppelaars

Other related posts:

» Rewrite into SQL- amonte
» Re: Rewrite into SQL- Stephane Faroult
» Re: Rewrite into SQL- Toon Koppelaars
» Re: Rewrite into SQL- amonte
» Re: Rewrite into SQL- Toon Koppelaars
» Re: Rewrite into SQL - gokulkumar gopal