读书探究世界的博客

//三表联合查询 /* * select t.* from product t,category c,categorysecond cs WHERE t.csid = cs.csid and c.cid = cs.cid and c.cid = 1 */

<select id="queryInfo" resultMap="BaseCustomerResultMap"> select t.*, c.num,c.communicateTime from t_baseimportcustom t LEFT JOIN ( SELECT tt.baseId,

function getSql(Clpfbh1 varchar2,Clpfbh2 varchar2,Clpfbh3 varchar2,Clpfbh4 varchar2) return varchar2 is sqlDeal varchar2(3000) := 'create or replace view xmxxdb_v as '; sqlgroupby number :...