oracle 视图的创建，游标，left join

Oracle 游标使用： http://www.cnblogs.com/sc-xx/archive/2011/12/03/2275084.html

显式游标：

隐式游标：

在表的连接时，有 主表 left outer join 副表 效果一般会比直接内连接要好

内连接使用java代码的代替：可以，拼接字段：

for (Map<String, Object> matContractStockBill : matContractStockBillList) {
                String billCode = (String) matContractStockBill.get("BILL_CODE_");
                List<Map<String, Object>> matContractStockList = MatContractStockService.selectMatContractStock(billCode, null, null, null, null, null, null, null, null, 1, -1, operator);
                String BILL_CONTEXT_ = "";
                for (Map<String, Object> matContractStock : matContractStockList) {
                    String billContext = matContractStock.get("MAT_DESC_") + "(" + matContractStock.get("AMOUNT_") + ")";
                    BILL_CONTEXT_ += billContext + ",";
                }
                matContractStockBill.put("BILL_CONTEXT_", BILL_CONTEXT_);
            }

oracle 视图的创建，游标，left join

标签：内连接   tor   desc   list   esc   htm   rac   ref   www