hi
how can i generate an automatic user id for oracle db,.
in my requirement, i have a jsp page with set of fileds, and a "Add button" .
Whenever the user submits the "Add button" the
db has to generate an auto user id for that and insert into db.
need help
Thnks
hi
in the given link,
http://www.datanamic.com/support/autoinc-oracle.html
it says that
To make an Oracle autoincrement column in DeZign for Databases:
Select Dictionary | Sequences from the application menu.
In the Sequences dialog, add a new sequence (let's say Sequence_1). Press OK to save your changes.
Go to the Entity dialog of the entity which owns
--
i didnt get to the point --" select dictionary | sequence from app menu"
where to look for it ?
pls i need ur help.
tnx
Hint, if you definie a field as SERIAL, then the ID sequence will be created for you automatically on schemename.tablename_id_seq.
LikeCREATE TABLE schemename.tablename (
ID SERIAL PRIMARY KEY,
...
);
Oracle and PostgreSQL only tho. Other DB's uses AUTO_INCREMENT (MySQL) or IDENTITY (MSSQL, DB2)
