incrementing function in Oracle

From: Kah-Tat Lim <kahtat_at_yahoo.com>
Date: Tue, 3 Jul 2001 19:10:27 +0800
Message-ID: <9hs96g$mpv$1@dahlia.singnet.com.sg>

dear all,

need your help on this,

the problem that I am facing is

i have 3 tables (for e.g) i) Card Table ii) Room Table iii) Meeting Table
what should i do when everytime when a record is to be created in each of these tables, i would want to increment a certain field in the tables by 1, for e.g when a record is to be inserted into Card Table the Card ID field is to be incremented by 1, that means if the present record in Card Table have the Card ID of 8901, once an insertion of a record is to be done in Card Table, the Card ID will have to be 8902.

as i have to prior experience in this before, can anyone help? thanks Received on Tue Jul 03 2001 - 06:10:27 CDT