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

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

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