Terima kasih p' Wibowo, saya dah implementasikan. Mungkin satu lagi yang bikin
saya bingung, ketika saya akan pergunakan untuk Autonumber pada sebuah tabel
(cth: TBL_PASIEN "NO_MR VARCHAR(6), NAMA_PASIEN VARCHAR(50)") saya execute
lewat trigger before insert tidak berfungsi. Mungkin p' Wibowo atau
temen-temen senior lainnya bisa memberikan contoh dan pencerahannya lagi.
Terima Kasih.
"KEEP EXIST WITH US"
Yulius Wibowo <[EMAIL PROTECTED]> wrote: 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]
>
--
-----------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
SPONSORED LINKS
Membership database
software Database mortgage software
Pda database software
Database management
software Oracle database
administration Oracle database
management
---------------------------------
YAHOO! GROUPS LINKS
Visit your group "indo-oracle" on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
---------------------------------
Yahoo! Photos
Ring in the New Year with Photo Calendars. Add photos, events, holidays,
whatever.
[Non-text portions of this message have been removed]
--
-----------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/
