Lama karena di parsing berulang2...
Mungkin kalau data1,data2, & data3 diambil dari table.
Kita bisa menggunakan "MERGE Statement Syntax".
contoh:
MERGE INTO copy_emp AS c
USING employees e
ON (c.employee_id = e.employee_id)
WHEN MATCHED THEN
UPDATE SET
c.first_name = e.first_name,
c.last_name = e.last_name,
c.email = e.email,
c.phone_number = e.phone_number,
c.hire_date = e.hire_date,
c.job_id = e.job_id,
c.salary = e.salary,
c.commission_pct = e.commission_pct,
c.manager_id = e.manager_id,
c.department_id = e.department_id
WHEN NOT MATCHED THEN
INSERT VALUES(e.employee_id, e.first_name,
e.last_name,
e.email, e.phone_number, e.hire_date, e.job_id,
e.salary, e.commission_pct, e.manager_id,
e.department_id);
Salam,
Iw
--- SIMASDAM <[EMAIL PROTECTED]> wrote:
>
> Dear netters...
>
>
>
> Saya mau updating table dengan cara
>
>
>
> UPDATE table
>
> SET field2 = data2, field3 = data3
>
> WHERE field1 = data1;
>
> IF SQL%NOTFOUND THEN
>
> INSERT INTO table
>
> (field1,field2,field3)
>
> VALUES
>
> (data1,data2,data3);
>
> END IF;
>
>
>
> Namun performance-nya (dalam hal ini waktu yang
> dibutuhkan, berdasarkan
> pengamatan kasar melalui penunjuk waktu) lebih lama
> (hampir 2 x
> lipat)dibanding langsung insert data.
>
>
>
> INSERT INTO table
>
> (field1,field2,field3)
>
> VALUES
>
> (data1,data2,data3);
>
>
>
> Pertanyaan saya
>
> 1. mengapa perbedaan waktunya sangat signifikan.
> 2. apakah ada cara lain yang bisa saya lakukan untuk
> update
> sekaligus insert kalau datanya tidak ditemukan.
>
> Mohon maaf kalau pertanyaannya sudah pernah ada.
>
> Terima kasih atas jawabannya.
>
>
>
> [Non-text portions of this message have been
> removed]
>
>
>
> --
> -----------I.N.D.O - O.R.A.C.L.E---------------
> Keluar: [EMAIL PROTECTED]
> Website: http://indo-oracle.blogspot.com
> -----------------------------------------------
>
> Bergabung dengan Indonesia Thin Client User Groups,
> Terminal Server, Citrix, New Moon Caneveral, di:
> http://indo-thin.vze.com
> Yahoo! Groups Links
>
>
> [EMAIL PROTECTED]
>
>
>
>
>
>
__________________________________
Do you Yahoo!?
Yahoo! Mail - You care about security. So do we.
http://promotions.yahoo.com/new_mail
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.blogspot.com
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indo-oracle/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
