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

来源:学生作业帮助网 编辑:作业帮 时间:2024/07/12 07:33:14
select '2012-12-05','2012-12-06','2012-12-07','2012-12-08' from DUAL,如何把这种一行转为一列.主要用意就是把几个指定的字符串弄成一列.
x)+NIM.QP7204"Su c̱PWH+Up uyީϺ^|y /ػɎ]@ӎzOv~Znlz XYg<];eOvlzYN"}zlN/*AK?[W#VQ]IT>6yv)7,

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