aku punya tabel kayak gini ..!
No KOBAR SITE TGL KODE_F BATCH JML
1 AP-AB1 PBCJ 3/29/2006 APA-604 604609 2215.2
2 AP-AB1 PBCJ 4/4/2006 APA-604 604643 2215.2
3 AP-AB1 PBCJ 4/4/2006 APA-604* 604650 1494.4
4 AP-AB1 PBCJ 4/5/2006 APA-604 604688 2215.2
5 AP-AB1 PBCJ 4/5/2006 APA-604* 604696 1494.4
6 AP-AB1 PBCJ 4/7/2006 APA-604 604710 2215.2
7 AP-AB1 PBCJ 4/7/2006 APA-604* 604718 1494.4
8 AP-AB1 PBCJ 4/11/2006 APA-604 604743 2215.2
9 AP-AB1 PBCJ 4/11/2006 APA-604** 604749 1494.4
10 AP-AB1 PBCJ 4/12/2006 APA-604 604776 2215.2
11 AP-AB1 PBCJ 4/13/2006 APA-603 604791 2223.2
12 AP-AB1 PBCJ 4/13/2006 APA-603* 604795 1499.4
13 AP-AB1 PBCJ 4/18/2006 APA-603 604806 2223.2
14 AP-AB1 PBCJ 4/18/2006 APA-603* 604814 1499.4
15 AP-AB1 PBCJ 4/19/2006 APA-603 604855 2223.2
16 AP-AB1 PBCJ 4/21/2006 APA-603** 604871 2223.2
17 AP-AB1 PBCJ 4/24/2006 APA-603 604890 2223.2
18 AP-AB1 PBCJ 4/24/2006 APA-603**** 604898 1499.4
19 AP-AB1 PBCJ 4/25/2006 APA-603 604918 2223.2
aku ingin outputnya :
1 AP-AB1 PBCJ 3/29/2006 APA-604 604609 2215.2
3 AP-AB1 PBCJ 4/4/2006 APA-604* 604650 1494.4
11 AP-AB1 PBCJ 4/13/2006 APA-603 604791 2223.2
12 AP-AB1 PBCJ 4/13/2006 APA-603* 604795 1499.4
16 AP-AB1 PBCJ 4/21/2006 APA-603** 604871 2223.2
18 AP-AB1 PBCJ 4/24/2006 APA-603**** 604898 1499.4
aku udah looping kayak gini
FOR data_ IN get_data LOOP
if (kode_ <> data_.kode) or (row_no_ = 1) THEN
INSERT INTO INFO_SERVICES_RPT (
result_key,
row_no,
parent_row_no,
S1,
S3, S4,
S5, S6,
S7,
N1, D1,
D2,
D3)
VALUES (
result_key_,
row_no_,
0,
kobar_,
contract_,
data_.ko,
data_.no_batch,
user_,
supervisor_,
data_.jumlah,
date_entered1_,
date_entered2_,
data_.tanggal);
row_no_ := row_no_ + 1; end if;
kode_ := data_.kode;
END LOOP;
thanks for advance !
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.lizt.org (NEW)
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
YAHOO! GROUPS LINKS
- Visit your group "indo-oracle" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
