Kalau untuk memasukkan sequence ke field (id) nggak perlu pake trigger. Jadi untuk memasukkan sequence ke id cukup pake query insert sbb: >INSERT INTO table_name (id,name) VALUES (nama_sequence.nextval, 'Nama') >/ Jadi, No trigger is required :D
CMIIW 'Kholeel' thejavafreak <[EMAIL PROTECTED]> wrote: Sebelumnya terima kasih banyak mas. Jadi yang saya harapkan adalah setiap kali saya memasukkan data ke table sbb: id INT name VARCHAR2 column id akan memanggil sequence tsb. Berarti harus bikin trigger kan? Cuma saya tidak mengerti sintaks untuk triggernya. thnx in advance > Bikin dulu sequence-nya mis. > CREATE SEQUENCE supplier_seq > START WITH 1 > INCREMENT BY 1; > > Untuk memanggil ketik perintah: > SELECT supplier_seq.nextval FROM DUAL; > > regards, > AWAL > > > > > ----- Original Message ----- > From: thejavafreak > To: [email protected] > Sent: Thursday, June 15, 2006 3:40 PM > Subject: [indo-oracle] Trigger untuk sequence > > > Bagaimana syntax untuk bikin trigger memanggil sequence seperti > AUTO_INCREMENT di MySQL? Terima kasih sebelumnya > > > > > > > [Non-text portions of this message have been removed] > --------------------------------- Want to be your own boss? Learn how on Yahoo! Small Business. [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Yahoo! Groups gets a make over. See the new email design. http://us.click.yahoo.com/XISQkA/lOaOAA/yQLSAA/PhFolB/TM --------------------------------------------------------------------~-> -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com Mirror: http://indooracle.wordpress.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.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/
