Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #107.65K
1 Posted Topic
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
The End.