有没有办法在SQL中将每个值作为一行返回

Hi we know that is we do the following query in Oracle SQL we get each value as a column and will return the value as value in each column.

大家好我们知道,我们在Oracle SQL中执行以下查询,我们将每个值作为列,并将值作为值返回到每列中。

select 'Draft','Submitted','Cancelled','Accepted','Accepted and Modified','Open','Pending','Seller Reject' from dual;

Is there a way to return each value as a new row under single column?

有没有办法将每个值作为单列下的新行返回?

Thanks in advance!

提前致谢!

2 个解决方案

#1

I tried this and it works:

我试过这个并且它有效:

select 'Draft' as Enum
union
select 'Submitted' as Enum
union
select 'Cancelled' as Enum
union
select 'Accepted' as Enum
union
select 'Accepted and Modified' as Enum
union
select 'Open' as Enum
union
select 'Pending' as Enum
union
select 'Seller Reject' as Enum

This will work on SQL Server.

这将适用于SQL Server。

But for oracle, please add the from claus in each select query like select 'Seller Reject' as Enum from Dual

但是对于oracle,请在每个选择查询中添加from claus,例如选择'Seller Reject'作为Enum from Dual

2 个解决方案

#1

更多相关文章

随机推荐