944768 wrote:this is a SQL issue. This forum is for SQL Developer (not for general SQL/PL/SQL questions) to discuss issues relating specifically to SQL*DEveloper. The issue you described will affect any Oracle development tool.
i want to insert unique number with out gaps in a col of a table every time my query runs . it shouel generate numbers from 1 to n.
i can do it using sequence , but sequence need reseting and other user can reset it also and it creats gaps too.
so please tel me is there any function/technique which can give me session or transaction specific unique number on each call to sp.
pls consider i want to inserting these numbers in a table and insertion is going on in a loop.
Marwim wrote:There will be weeping and gnashing of teeth on April 15. Not because of the new golden era on OTN (although that remains a possiblity) but because that's the day taxes are due in the US
April 15th will be the beginning of a new golden era of this forum. I'm sure it will include an omniscient search feature :-)
Until then it's the best to include "site:forum.oracle.com" in your google searchExcellent advice!