0

When some datas are inserted in to a DB table from a jsp page, how do i get the primary key in my table autogenerated?? finiding out the highest value for the primary key in the table? Pls help me wid the coding in JAVA or HTML.. I use SQL*PLus.

4
Contributors
3
Replies
4
Views
8 Years
Discussion Span
Last Post by emsm
0

you need to create a sequence. As you can guess this is an object that gives you numbers from sequence. then you should get next value from sequence. so you will always have different pk. here is a link that shows you how to create and use it.
after creating it you will probably do something like that

insert into a(pk,col1,col2) values (sqn.nextval,'value1','value3')

0

I dont want to revive a 2008 post but i think ill save somene time, if the table is empty ull get an error simply using max+1, i finally choose to use the NVL2 handy function to get this:

SELECT NVL2(MAX(CODE_COLUMN),MAX(CODE_COLUMN)+1,1) NEXT_CODE_COLUMN FROM TABLE_NAME

Edited by emsm: n/a

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.