select '2012-12-05','2012-12-06','2012-12-07','2012-12-08' from DUAL,如何把这种一行转为一列.主要用意就是把几个指定的字符串弄成一列.

来源:学生作业帮助网 编辑:作业帮 时间:2024/05/06 21:37:52
select '2012-12-05','2012-12-06','2012-12-07','2012-12-08' from DUAL,如何把这种一行转为一列.主要用意就是把几个指定的字符串弄成一列.

select '2012-12-05','2012-12-06','2012-12-07','2012-12-08' from DUAL,如何把这种一行转为一列.主要用意就是把几个指定的字符串弄成一列.
select '2012-12-05','2012-12-06','2012-12-07','2012-12-08' from DUAL,如何把这种一行转为一列.
主要用意就是把几个指定的字符串弄成一列.

select '2012-12-05','2012-12-06','2012-12-07','2012-12-08' from DUAL,如何把这种一行转为一列.主要用意就是把几个指定的字符串弄成一列.
可以这样
select '2012-12-05' from DUAL
union all
select '2012-12-06' from DUAL
union all
select '2012-12-07' from DUAL
union all
select '2012-12-08' from DUAL