Anda nggak bisa menambahkan constraint dengan menggunakan option MODIFY. Untuk menambahkan constraint di sebuah table, gunakan: SQL> ALTER TABLE mhs ADD CONSTRAINT mhs_jurusan_fk FOREIGN KEY (jurusan) REFERENCES jurusan(jurusan);
Bowo --- In [email protected], "Surya A. Saputra" <[EMAIL PROTECTED]> wrote: > Dear Indo, > > SQL> alter table mhs > 2 modify (jurusan char(2) references jurusan(jurusan)); > modify (jurusan char(2) references jurusan(jurusan)) > * > ERROR at line 2: > ORA-02253: constraint specification not allowed here > > Ini maksud errornya apaan yah ? > Thanks atas masukkannya. > > 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/
