--- Awaluddin Hamid <[EMAIL PROTECTED]> wrote:
> Kalau table TBTRAINING sudah berhasil diisi record
> maka
> coba di table TBHTRAINING tambahkan satu kolom ID yg
> merefer ke kolom ID
> di table TBTRAINING trus isi kolom tsb. via pseudo
> procedure:
> DECLARE
> BEGIN
> FOR rec IN (SELECT ID, mulai, selesai FROM
> TBTRAINING) LOOP
> UPDATE TBHTRAINING set ID = rec.ID WHERE
> mulai = rec.mulai
> AND selesai = rec.selesai;
> END LOOP;
> END;
> /
=My Reply=
Hmm, kalo cara diatas menurut analisa saya gak bisa,
karena TBHTRAINING itu history training utk setiap
karyawan. N, Misalkan ada training dari tgl 1-3,
sedangkan karyawan A cuma ikut tgl 3, gak ketemu kan
IDnya.
> Untuk insert ke table TBDTRAINING tinggal pake
> perintah SQL:
> INSERT INTO TBDTRAINING
> (ID,int_id,mulai,selesai,laporan,sertifikat)
> SELECT ID,int_id,mulai,selesai,laporan,sertifikat
> FROM TBHTRAINING;
=My Reply=
Thx, atas sarannya, sudah jadi koq. saya pake query
berikut ini:
----------------------------------------------------
insert into tbdtraining
select tbtraining.id, tbhtraining.int_id,
tbhtraining.MULAI, tbhtraining.SELESAI,
tbhtraining.JMLHARI, tbhtraining.LAPORAN,
tbhtraining.SERTIFIKAT
from tbtraining, tbhtraining
where upper(tbtraining.judul)=upper(tbhtraining.topik)
and
(tbhtraining.MULAI between tbtraining.tglmulai
and tbtraining.TGLSELESAI) and
(tbhtraining.selesai between tbtraining.tglmulai
and tbtraining.TGLSELESAI)
-----------------------------------------------------
(ide utk pake BETWEEN tiba2 muncul dlm pikiranku,
hehehehehehe...)
Selama ini saya pake SELECT blablabla INTO.....
Ternyata INSERT-nya duluan, hehehe,..baru2 pake
Oracle, n susah mencari common syntax SQLnya Oracle.
Mungkin ada yg tau sumber referensi yg bagus tentang
syntax2 SQL-nya Oracle?
BTW, thx atas responnya. ^_^
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
