Thx alot Poer
On Thu, 26 May 2005 13:16:36 -0000 "Yulius Wibowo" <[EMAIL PROTECTED]> wrote: > Kalau pakai constraint kayaknya nggak bisa deh, > Tapi kalau pakai cara lain, misal menggunakan TRIGGER di >level table > atau di level aplikasi dimungkinkan .... > > Contoh kalau trigger dipasang di table table_b > > SQL> CREATE OR REPLACE TRIGGER check_qty > AFTER INSERT OR UPDATE ON table_b > FOR EACH ROW > BEGIN > DECLARE > v_qtya table_a.qty%TYPE; > BEGIN > SELECT qty INTO v_qtya FROM table_a WHERE >(..kondisi..); > IF :NEW.qty > v_qtya THEN > RAISE_APPLICATION_ERROR(-20000,'QTY kegedean...'); > END IF; > END; > END; > / > > Kalau diaplikasi, misal form developer, bisa digunakan >trigger WHEN- > VALIDATE-ITEM. > > Bowo > > --- In [email protected], "Purwandi" ><[EMAIL PROTECTED]> wrote: > > Salam Semua > > > > Saya mau nanya tentang Constraint. > > Bisa nagak kita bikin Constraint pada sebuah field >dengan > > membaca table yang lain > > > > contoh > > table A > > > > no_fak code qty > > 001 A 2 > > 001 B 4 > > 002 A 5 > > 002 B 6 > > 002 C 7 > > > > table B > > no_fak code qty > > 001 A .... > > 001 B .... > > 002 A .... > > 002 B .... > > 002 C .... > > > > > > Bisa ngak kalau kita bikin Constraint di table B >(filed > > qty), bahwa nilainya tdk boleh melebihi filed qty di >table > > A > > Demikian pertanyaan saya, mohon rekan2x bersedia >membantu > > Thx > > > > Poer > > > ====================================================================== > ================== > > Akses Internet TELKOMNet-Instan beri Diskon s.d. 50 % >khusus untuk > wilayah Jawa Timur. > > Informasi selengkapnya di www.telkomnetinstan.com atau >hub 0800-1- > INSTAN (467826) > > > ====================================================================== > ================== > > > > > -- > -----------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 the Yahoo! >Terms of Service. ======================================================================================== Akses Internet TELKOMNet-Instan beri Diskon s.d. 50 % khusus untuk wilayah Jawa Timur. Informasi selengkapnya di www.telkomnetinstan.com atau hub 0800-1-INSTAN (467826) ======================================================================================== -- -----------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/
