如何用oracle重复数据行 [英] How to repeat data row with oracle
问题描述
大家好,
我不知道怎么问你,但我会一步一步向你解释,告诉你我想要什么。
我有一张表存储如下数据:
无类型
------- ------------------------
1 1.Micro 1-1,500 1
2 2 .Micro 1,501-2,000
3 3.Micro 2,001-3,000
4 4.Small 3,001-5,000
5 5.Small 5,001-10,000
6 6.Medium 10,001-30,000
7 7.SME 30,001-100,000
和另外一张桌子
名称
----------
0203
0204
0206
0303
和我想要的数据是这样的:
名称类型
----------------------------------
203 1。微1-1,500
203 2.Micro 1,501-2,000
203 3.Micro 2,001-3,000
203 4.Small 3,001-5,000
203 5.Small 5,001-10,000
203 6.Medium 10,001-30,0 00
203 7.SME 30,001-100,000
204 1.Micro 1-1,500
204 2.Micro 1,501-2,000
204 3.Micro 2,001-3,000
204 4.Small 3,001-5,000
204 5.Small 5,001-10,000
204 6.Medium 10,001-30,000
204 7.SME 30,001-100,000
206 1.Micro 1-1,500
206 2.Micro 1,501- 2,000
206 3.Micro 2,001-3,000
206 4.Small 3,001-5,000
206 5.Small 5,001-10,000
206 6.Medium 10,001-30,000
206 7.SME 30,001-100,000
303 1.Micro 1-1,500
303 2.Micro 1,501-2,000
303 3.Micro 2,001-3,000
303 4.Small 3,001-5,000
303 5.Small 5,001- 10,000
303 6.Medium 10,001-30,000
303 7.SME 30,001-100,000
任何人都可以帮助我.......... :(
Hi all,
I don't know how to ask you, but i will explain you with a step by step and show you what I want.
I have a table that store like data below :
No Type
-------------------------------
1 1.Micro 1-1,500 1
2 2.Micro 1,501-2,000
3 3.Micro 2,001-3,000
4 4.Small 3,001-5,000
5 5.Small 5,001-10,000
6 6.Medium 10,001-30,000
7 7.SME 30,001-100,000
and one more table
Name
----------
0203
0204
0206
0303
and data I want is like this:
Name Type
----------------------------------
203 1.Micro 1-1,500
203 2.Micro 1,501-2,000
203 3.Micro 2,001-3,000
203 4.Small 3,001-5,000
203 5.Small 5,001-10,000
203 6.Medium 10,001-30,000
203 7.SME 30,001-100,000
204 1.Micro 1-1,500
204 2.Micro 1,501-2,000
204 3.Micro 2,001-3,000
204 4.Small 3,001-5,000
204 5.Small 5,001-10,000
204 6.Medium 10,001-30,000
204 7.SME 30,001-100,000
206 1.Micro 1-1,500
206 2.Micro 1,501-2,000
206 3.Micro 2,001-3,000
206 4.Small 3,001-5,000
206 5.Small 5,001-10,000
206 6.Medium 10,001-30,000
206 7.SME 30,001-100,000
303 1.Micro 1-1,500
303 2.Micro 1,501-2,000
303 3.Micro 2,001-3,000
303 4.Small 3,001-5,000
303 5.Small 5,001-10,000
303 6.Medium 10,001-30,000
303 7.SME 30,001-100,000
any body can help me please..........:(
推荐答案
试一下
Try this
SELECT Name, Type
FROM FirstTable, Second Table;
这个概念称为CROSS JOIN。
通过此链接CROSS JOIN示例
很棒它正常工作并显示我想要的东西。
谢谢你非常pradiprenushe
Great it works correctly and show what I want.
Thanks you very much pradiprenushe
这篇关于如何用oracle重复数据行的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!