IQueryable q1 = dc.createUserCommand("explain plan for select * from yyyymmdd_tblc") ;
int result = q1.execUpdate() ;
}
public void testPlanView() throws Exception {
Queryable q1 = (Queryable)dc.createUserCommand("explain plan for select * from copy_tblc") ;
Queryable q2 = (Queryable)dc.createUserCommand("select substr (lpad(' ', level-1) || operation || ' (' || options || ')',1,30 ) Operation, object_name Object " +
" from plan_table start with id = 0 connect by prior id=parent_id") ;
CombinedUserProcedures upts = new CombinedUserProcedures(dc, "plan_view") ;
upts.add(q1, "query", IQueryable.UPDATE_COMMAND).add(q2, "plan", IQueryable.QUERY_COMMAND) ;