实现AAAZ,ZZZA,ZAZA,XABB,AXAA,AXBB,AZZA,AAZZ,XXA8这些组合， 需要写成存储过程去执行，怎么写啊，求高手解答没明白你什么意思，看不懂。 结果就是看有多少组合，例如AAAZ就有2360,2231等 把所有的组合都列出来就好了 多表连接产生笛卡尔积 比如AAAZ: SQL code: WITH t AS( SELECT ROWNUM-1 rn from dual CONNECT BY ROWNUM<=10) ,A AS( SELECT rn v from t WHERE rn IN(2,3,6,8,9)) ,Z AS( SELECT rn v from t WHERE rn IN(0,1,4,5,7)) SELECT a1.v||a2.v||a3.v||z.v from A a1,A a2,A a3,Z
CREATE OR REPLACE PROCEDURE usp_refreshTopN IS BEGIN --文档 INSERT INTO topnresource(resourceId,title,type,cover,brief,properUser,tag,clickAmount,createDate,topNCreateDate,organizat ......
