甲骨文获得范围的数字 [英] Oracle get numbers with range
本文介绍了甲骨文获得范围的数字的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
这是我的序列表:
+-----------------+-----------------+
| START_SERIAL | END_SERIAL |
+-----------------+-----------------+
| 120500216057150 | 120500216057155 |
| 120500216057157 | 120500216057157 |
| 120500216057161 | 120500216057164 |
+-----------------+-----------------+
需要这样的结果:
120500216057150
120500216057151
120500216057152
120500216057153
120500216057154
120500216057155
120500216057157
120500216057161....
请帮助我解决此问题. [似乎需要带for循环的pl-sql.?]
Please help me to sort out this issue. [seems need pl-sql with for loop needed.?]
编辑 亲爱的TechDo, 那么pl/sql的用法如下所示,但是它给了我一个错误:-)
EDIT dear TechDo, What about pl/sql usage here as follows.but its gives me a error :-)
DECLARE
start_serial NUMBER;
end_serial NUMBER;
records NUMBER;
BEGIN
select start_serial INTO start_serial
from sales_details ;
select (start_serial+no_of_cards)as end_serial into end_serial
from sales_details;
select count(*) as records into records
from sales_details;
FOR i IN 1..records LOOP
INSERT INTO temp (serial_no)
VALUES(i);
END LOOP;
END;
/
推荐答案
请尝试:
select
distinct START_SERIAL+level-1 SERIAL
from
YourTable
connect by level-1<=END_SERIAL-START_SERIAL
order by 1;
这篇关于甲骨文获得范围的数字的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文