Clam.

select t.no, case when t.no >= 1 then 1 || '*' || t.no || '=' || 1 * t.no else '' end a, case when t.no >= 2 then ...

select max(decode(to_char(dt, 'day'), '星期日', to_char(dt, 'dd'))) "星期日", max(decode(to_char(dt, 'day'), '星期一', to_char(dt, 'dd'))) "星期一", max(decode(to_char(dt, 'day'), '星期二', to_cha...

select colunmnid,connect_by_root(colunmnid) precolumnid from Test WHERE precolumnid IS NOT null connect by prior colunmnid= precolumnid order by 1,2 Create Table Test(colunmnid Integer,pre...