Re: Datatype Question

From: Avi-Abrami <abramia_at_PROBLEM_WITH_INEWS_GATEWAY_FILE>
Date: 1996/12/09
Message-ID: <58g52c$3eh2_at_lmpsbbs.comm.mot.com>#1/1

Lam Sze Wai (bm_lswaa_at_uxmail.ust.hk) wrote:
> Can anyone kindly tell me whether there exists a datatype
> that when a new record is added, its value automatically
> is increased by one? How can I access it using Pro*C?
> Thank you.

I believe what you are looking for is the ORACLE sequence. If you have online help, then after entering SQL*Plus, type the following command:

    help create sequence

or lookup the command in your ORACLE reference manuals.

Hope this helps,
Avi.

---

Avi Abrami - A/P
Pelephone Comms Ltd
Tel-Aviv, Israel. Received on Mon Dec 09 1996 - 00:00:00 CET