zhang@zhang>select col from (
2 select col1 col, rownum id from test2
3 union all
4 select col2 col, rownum id from test2
5 union all
6 select col3 col, rownum id from test2
7 union all
8 select col4 col, rownum id from test2
9 union all
10 select col5 col, rownum id from test2
11 union all
12 select col6 col, rownum id from test2
13 )
14 order by id, rownum;COL
--------------------
5
宜昌房网
山水云间
宜昌市夷陵区松湖路
0717-7892888
夏经理
6
宜昌房网
君临山水
夷陵区夷兴大道神仙湾
0717-519888212299
--
2 select col1 col, rownum id from test2
3 union all
4 select col2 col, rownum id from test2
5 union all
6 select col3 col, rownum id from test2
7 union all
8 select col4 col, rownum id from test2
9 union all
10 select col5 col, rownum id from test2
11 union all
12 select col6 col, rownum id from test2
13 )
14 order by id, rownum;COL
--------------------
5
宜昌房网
山水云间
宜昌市夷陵区松湖路
0717-7892888
夏经理
6
宜昌房网
君临山水
夷陵区夷兴大道神仙湾
0717-519888212299
--
解决方案 »
- oracle 时间查询的问题,可能与时区相关,TRUNC函数
- 求 系统内主数据等基础数据表结构设计 好的办法、方案
- oracle 不能查询操作吗? 为啥查询的存储过程执行不了。
- Oracle Database 10g Express Edition如何使用UTL_FILE?
- 我是菜鸟,需要帮忙,(帮忙看看下面的语句的问题)
- oracle8i中Oracle EnterPrise Manager的默认管理员密码是多少??
- 老问题,但前面解决方法没有可行的:oracle8.05用exp导出的dmp文件不能用imp导入oracle8.16
- 好的oracle学习网站/我的疑惑
- Oralce运行变慢,重启恢复
- oracle中between..and..的非常容易错误的使用点:字符串,数字的区间比较
- 行转列的问题?请大家指教
- 问树型结构的查询语句
你总共有6列,分别叫作F1,F2,F3,F4,F5,F6.表名T1
Select C From (
Select C1 AS C , C1 || '1' AS ORDERID FROM T1
UNION ALL
Select C2 AS C , C1 || '2' AS ORDERID FROM T1
UNION ALL
Select C3 AS C , C1 || '3' AS ORDERID FROM T1
UNION ALL
Select C4 AS C , C1 || '4' AS ORDERID FROM T1
UNION ALL
Select C5 AS C , C1 || '5' AS ORDERID FROM T1
UNION ALL
Select C6 AS C , C1 || '6' AS ORDERID FROM T1
)
Order By OrderID