Kalau yang anda maksud sperti auto increment di mysql, maka harus
dibuat sequence dan trigernya.
contohnya:
CREATE OR REPLACE TRIGGER nama_triger BEFORE INSERT
ON nama_table
FOR EACH ROW
DECLARE
tmpVar NUMBER;
BEGIN
tmpVar := 0;
SELECT SEQ_ANAK.NEXTVAL INTO tmpVar FROM dual;
:NEW.namakolomutonumber := tmpVar;
END;
CREATE SEQUENCE nama_sequence
START WITH 0
MAXVALUE 1E27
MINVALUE 0
NOCYCLE
NOCACHE
NOORDER;
--- In [email protected], Jemmy <[EMAIL PROTECTED]> wrote:
>
> Salam kenal, n sekalian numpang bertanya,
>
> Di Oracle bagaimana caranya kalo saya mo buat satu
> field yg sifatnya auto number?
>
> Sori kalo pertanyaannya terkesan bodoh, saya baru pake
> Oracle, n sudah cari di dokumentasi gak ketemu juga.
>
> Thank's b4.
>
>
>
>
____________________________________________________________________________________
> No need to miss a message. Get email on-the-go
> with Yahoo! Mail for Mobile. Get started.
> http://mobile.yahoo.com/mail
>
