Auto increment untuk sebuah table, maka hrs dibuatkan
triger dan sequencenya. Mis:
CREATE SEQUENCE NAMA_SEQUENCE
START WITH 1
MAXVALUE 1E27
MINVALUE 0
NOCYCLE
NOCACHE
NOORDER;
--AK_TRG
--
CREATE OR REPLACE TRIGGER NAMA_TRIGER BEFORE INSERT
ON NAMA_TABLE
FOR EACH ROW
DECLARE
tmpVar NUMBER;
BEGIN
tmpVar := 0;
SELECT NAMA_SEQUENCE.NEXTVAL INTO tmpVar FROM dual;
:NEW.COLUMN_DALAM_TABLE := tmpVar;
END;
/
--- gede sudi <[EMAIL PROTECTED]> wrote:
> pak Ferry, bisa dijelaskan lebih detail tentang
> penggunaan sequence
> terutama dipakai dalam salah satu bahasa
> pemrograman. Ato bisa
> diberikan alamant yang bisa membantu hal di atas.
>
> Sebelumnya terima kasih.
>
> On 6/21/06, Ferry Setiawan
> <[EMAIL PROTECTED]> wrote:
> > pakai sequence
> >
> > > -----Original Message-----
> > > From: [email protected]
> [mailto:[EMAIL PROTECTED]
> > > Behalf Of gede sudi
> > > Sent: 21 Juni 2006 13:02
> > > To: [email protected]
> > > Subject: [indo-oracle] Auto increment di Oracle
> > >
> > >
> > > Halo milis, aku mo tanya
> > >
> > > Gimana caranya melakukan auto increment (seperti
> di mysql) untuk
> > > di Oracle?
> > > Saya menggunakan tipe data number. Masalah ini
> adalah untuk menambah ID
> > > setiap user yang terdaftar.
> > >
> > > Thanks sebelumnya atas bantuannya.
> >
> >
> >
>
>
> --
> -----------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
>
>
> [EMAIL PROTECTED]
>
>
>
>
>
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
------------------------ 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/
