甲骨文获得带范围的数字

请试试：

select   distinct START_SERIAL+level-1 SERIALfrom   YourTableconnect by level-1<=END_SERIAL-START_SERIALorder by 1;