Mau bikinnya dimana? Di database via SQL> a/ SQL-developer lainnya: Create trigger <nama_trigger> Before insert on <nama_tabel> referencing new as new for each row begin select <nama_sequence>.nextval into :new.id from dual; end; /
Di aplikasi via Form developer, mis. gunakan trigger Pre-Insert: DECLARE CURSOR cur IS SELECT <nama_sequence>.NEXTVAL FROM dual; BEGIN OPEN cur; FETCH cur INTO :<nama_block>.Id; CLOSE cur; END; regards, AWAL ----- Original Message ----- From: thejavafreak To: [email protected] Sent: Tuesday, June 20, 2006 1:00 PM Subject: [indo-oracle] Re: Trigger untuk sequence 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] > [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Great things are happening at Yahoo! Groups. See the new email design. http://us.click.yahoo.com/TISQkA/hOaOAA/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/
