Oracle View creation, cursors, left join

Creation of the View:

Create or Replace View  as Select csib. * , Sib. Stock_io_,sib. Confirm_date_ from dm_mat_contract_stock_in_bill csibleftouter  Joinon= sib. Bill_code_;

Oracle cursors using: http://www.cnblogs.com/sc-xx/archive/2011/12/03/2275084.html

an explicit cursor :

An implicit cursor:

When a table is connected, there is a primary table left OUTER join table effect is generally better than the direct inner connection

Internal connections using Java code instead: Yes, splicing fields:

 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 View creation, cursors, left join