Bisa pakai SEQUENCE SQL> CREATE SEQUENCE seq1; SQL> CREATE TABLE test1(A NUMBER);
SQL> INSERT INTO test1 VALUES(seq1.NEXTVAL); SQL> INSERT INTO test1 VALUES(seq1.NEXTVAL); SQL> INSERT INTO test1 VALUES(seq1.NEXTVAL); SQL> SELECT * FROM test1; ----------- SQL> CREATE SEQUENCE seq2 START WITH 100 INCREMENT BY 10; SQL> CREATE TABLE test2(A NUMBER); SQL> INSERT INTO test2 VALUES(seq2.NEXTVAL); SQL> INSERT INTO test2 VALUES(seq2.NEXTVAL); SQL> INSERT INTO test2 VALUES(seq2.NEXTVAL); SQL> SELECT * FROM test2; Bowo --- In [email protected], rahmat hidayat <[EMAIL PROTECTED]> wrote: > > temen2 senior... mo tanya > gimana caranya bikin no otomatis di database > > Terima kasih > > > > --------------------------------- > Yahoo! DSL Something to write home about. Just $16.99/mo. or less > > [Non-text portions of this message have been removed] > ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income homes are not online. Make a difference this holiday season! http://us.click.yahoo.com/5UeCyC/BWHMAA/TtwFAA/PhFolB/TM --------------------------------------------------------------------~-> -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.lizt.org (NEW) ----------------------------------------------- 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/
