1 5 package com.teamkonzept.db; 6 7 14 public class OracleStringFactory extends DBStringFactory { 15 16 private static final String NULL_INTEGER = " TO_NUMBER( NULL ) "; 17 private static final String IF_NULL_THAN = " nvl"; 18 private static final String ORACLE_TEMP = " GLOBAL TEMPORARY "; 19 private static final String ORACLE_TRANS = " ON COMMIT DELETE ROWS "; 20 private static final String CHECK_EXISTENCE = " SELECT TABLE_NAME FROM USER_CATALOG WHERE TABLE_NAME "; 21 private static final String ORACLE_FROM = " FROM DUAL "; 22 23 public String specDeclareAsTemp(){ 24 return ORACLE_TEMP; 25 } 26 27 public String specDeclareForTransaction(){ 28 return ORACLE_TRANS; 29 } 30 31 public String specNullValue(){ 32 return NULL_INTEGER; 33 } 34 35 36 protected String specNvl(){ 37 return IF_NULL_THAN; 38 } 39 40 protected String specCheckExistence(){ 41 return CHECK_EXISTENCE; 42 } 43 44 protected String specGetFromSystem(){ 45 return ORACLE_FROM; 46 } 47 48 49 protected String specLeftOuterJoin(String leftColumn, String rightColumn){ 50 return leftColumn + " = " + rightColumn + " (+) "; 51 } 52 53 protected String specRightOuterJoin(String leftColumn, String rightColumn){ 54 return leftColumn + " (+) = " + rightColumn; 55 } 56 57 protected String specLeftOuterJoinFrom(String [] columns, String leftTable, String rightTable){ 58 return leftTable + "," + rightTable; 59 } 60 61 protected String specRightOuterJoinFrom(String [] columns, String leftTable, String rightTable){ 62 return leftTable + "," + rightTable; 63 } 64 } 65 66 67 | Popular Tags |