|
〇〇 发表于 2014-10-30 11:16 ![]()
列出来看看
不会吧,连这个也要看?
SELECT DISTINCT LEAST(S,REVERSE(S))
FROM (
SELECT REPLACE(SYS_CONNECT_BY_PATH(N,','),',') S FROM (SELECT LEVEL N FROM DUAL CONNECT BY LEVEL<=5)
WHERE LEVEL=5
CONNECT BY NOCYCLE PRIOR N<>N
);
这题太简单,除非有人能证明是其他答案才能得到章。
|
|