oracle 視圖的建立，遊標，left join

標籤：內串連   tor   desc   list   esc   htm   rac   ref   www   

視圖的建立：

create or replace view dmv_mat_contract_stock_in_bill asselect csib.*,sib.STOCK_IO_,sib.CONFIRM_DATE_from DM_MAT_CONTRACT_STOCK_IN_BILL csibleft outer join DM_MAT_STOCK_IO_BILL sib on csib.BILL_CODE_ = sib.BILL_CODE_;

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