Hi All,
I want to create a table with two column, one is coming good with level but another one is also coming increasingly but I want second column output as
1.1
1.2
1.3
1.4
.
.
so on .
SELECT LEVEL lvl, (LEVEL + .1)--(LAG(LEVEL) OVER (ORDER BY LEVEL)) + 1 interest
FROM dual
CONNECT BY level <= 100;