3,491
社区成员
发帖
与我相关
我的任务
分享
select distinct(a.column_id),a.column_name,b.comments
from user_tab_columns a,user_col_comments b
where a.table_name =UPPER( 'dyml01') and b.table_name=UPPER('dyml01') and a.COLUMN_NAME = b.column_name
order by decode(a.column_id,4,1,2,2,1,3)
WITH a AS
(
SELECT 'a' t FROM dual UNION ALL
SELECT 'b' FROM dual UNION ALL
SELECT 'c' FROM dual)
SELECT * FROM a ORDER BY DECODE(t, 'a',1,'c',2,'b',3)
[/quote]他的意思应该是表列的顺序排序,select * from t ,结果是 列 a,列b,列c ,他要的结果是 列a,列c,列b[/quote]WITH a AS
(
SELECT 'a' t FROM dual UNION ALL
SELECT 'b' FROM dual UNION ALL
SELECT 'c' FROM dual)
SELECT * FROM a ORDER BY DECODE(t, 'a',1,'c',2,'b',3)
[/quote]他的意思应该是表列的顺序排序,select * from t ,结果是 列 a,列b,列c ,他要的结果是 列a,列c,列b[/quote]
没明白。。
比如select a,b,c from 表。。想查select a,c,b from 表???
如果是想适配结果集字段顺序的话,还是写函数重组sql好了。。
思路也是DECODE(t, 'a',1,'c',2,'b',3)。。WITH a AS
(
SELECT 'a' t FROM dual UNION ALL
SELECT 'b' FROM dual UNION ALL
SELECT 'c' FROM dual)
SELECT * FROM a ORDER BY DECODE(t, 'a',1,'c',2,'b',3)
[/quote]他的意思应该是表列的顺序排序,select * from t ,结果是 列 a,列b,列c ,他要的结果是 列a,列c,列bWITH a AS
(
SELECT 'a' t FROM dual UNION ALL
SELECT 'b' FROM dual UNION ALL
SELECT 'c' FROM dual)
SELECT * FROM a ORDER BY DECODE(t, 'a',1,'c',2,'b',3)