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.
lakshma.sugunan 0 Newbie Poster
yilmazhuseyin 16 Light Poster
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')
debasisdas 580 Posting Genius Featured Poster
you can use either a sequence or the max value of PK field +1 for the next unique not null value.
emsm 0 Newbie Poster
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
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.