This content has been marked as final. Show 3 replies
I would try it the other way round, include the number in your query and display it.
WITH NUMBERS AS (SELECT LEVEL NUMPOS FROM DUAL CONNECT BY LEVEL<4) SELECT NUMPOS, YOURDATA FROM YOUR_TABLE, NUMPOS WHERE JOIN
Is this only for existing record - to get from table, what if user create new record ? Pl clarify the point