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

Question

嗨，我们知道我们在 Oracle SQL 中执行以下查询，我们将每个值作为一列，并将该值作为每列中的值返回。

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

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

提前致谢!

Answer 1

我试过这个，它有效:

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

这将适用于 SQL Server。

但对于 oracle，请在每个选择查询中添加 from 子句，如 select 'Seller Reject' as Enum from Dual