Thanks for the question, Praveen.
Asked: April 01, 2020 - 7:00 am UTC
Last updated: April 03, 2020 - 10:11 am UTC
Version: 12c
Viewed 1000+ times
You Asked
How to Generate version Number using oracle SQL like rownum??
Need Result Like this 0.7,0.8,0.9,1.0,1.1,1.2 upto 4.5
and Connor said...
A little rownum and to_char should do the trick
select to_char((rownum+6)/10,'fm0.0') ver
from dual
connect by level < 40;
Rating
(2 ratings)
Is this answer out of date? If it is, please let us know via a Comment