Column yg bisa di referensi HANYALAH column dengan constraint PRIMARY KEY atau UNIQUE.
Jadi anda harus menmbahkan constraint PRIMARY KEY atau UNIQUE pada column nim yg ada di table mhs. SQL> ALTER TABLE mhs ADD CONSTRAINT mhs_nim_pk PRIMARY KEY(nim); Atau SQL> ALTER TABLE mhs ADD CONSTRAINT mhs_nim_u UNIQUE(nim); Setelah itu baru ... SQL> create table nilai (nim char(10) not null references mhs(nim), kode_matkul char(3) not null, 2 nilai varchar(3)); create table nilai (nim char(10) not null references mhs(nim), kode_matkul char(3) not null, ... Bowo --- In [email protected], "Surya A. Saputra" <[EMAIL PROTECTED]> wrote: > Dear Indo, > > SQL> create table nilai (nim char(10) not null references mhs(nim), kode_matkul char(3) not null, > 2 nilai varchar(3)); > create table nilai (nim char(10) not null references mhs(nim), kode_matkul char(3) not null, > * > ERROR at line 1: > ORA-02270: no matching unique or primary key for this column-list > > Yang ingin saya tanyakan apa itu konsep references dalam oracle dan > bagaimana cara membuat composite key (nim dan kode_matkul) dalam > oracle yang mana nim adalam foreign key. > > Thanks atas masukkannya, maklum masih baru belajar Oracle > > Best regards, > Surya A. Saputra > > Stop bunuh diri !! Hidup anda teramat berharga untuk disia-siakan > http://groups.yahoo.com/group/be-friends -- -----------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/
