select * from (
select 'user_id', 'user_name', 0 rn
from dual
union
select t.channel_id, t.module_name, rownum rn
from t_user t)
order by rn
oracle如何返回列名作为第一条数据简单解决
![](https://img2024.cnblogs.com/blog/35695/202405/35695-20240529225347158-1507288531.jpg)
select * from (
select 'user_id', 'user_name', 0 rn
from dual
union
select t.channel_id, t.module_name, rownum rn
from t_user t)
order by rn