SQL
-
编辑 删除
Oracle的Cast的用法
经常在前辈们的SQL中可以看到CAST,例如:WITH T AS(SELECT LEVEL||' ' L FROM DUAL CONNECT BY LEVEL<=5),A(A,V) AS(SELECT CAST(L AS VARCHAR(30)),1 FROM TUNION ALLSELECT A||L,V+1 FROM A, T WHERE INSTR(A,L)=0 AND V<5)SELECT * FROM A;例如上面的with递归语句，...
