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:
http://docs.yahoo.com/info/terms/
