@Override public void visit(Pivot pivot) { List<Column> forColumns = pivot.getForColumns(); buffer.append(" PIVOT (") .append(PlainSelect.getStringList(pivot.getFunctionItems())) .append(" FOR ") .append(PlainSelect. getStringList(forColumns, true, forColumns != null && forColumns.size() > 1)). append(" IN ") .append(PlainSelect.getStringList(pivot.getInItems(), true, true)) .append(")"); if (pivot.getAlias() != null) { buffer.append(pivot.getAlias().toString()); } }
@Override public String toString() { return "PIVOT (" + PlainSelect.getStringList(functionItems) + " FOR " + PlainSelect. getStringList(forColumns, true, forColumns != null && forColumns.size() > 1) + " IN " + PlainSelect.getStringList(getInItems(), true, true) + ")" + (alias!=null?alias.toString():""); } }
@Override public void visit(Pivot pivot) { List<Column> forColumns = pivot.getForColumns(); buffer.append(" PIVOT (") .append(PlainSelect.getStringList(pivot.getFunctionItems())) .append(" FOR ") .append(PlainSelect. getStringList(forColumns, true, forColumns != null && forColumns.size() > 1)). append(" IN ") .append(PlainSelect.getStringList(pivot.getInItems(), true, true)) .append(")"); if (pivot.getAlias() != null) { buffer.append(pivot.getAlias().toString()); } }
@Override public String toString() { return "PIVOT (" + PlainSelect.getStringList(functionItems) + " FOR " + PlainSelect. getStringList(forColumns, true, forColumns != null && forColumns.size() > 1) + " IN " + PlainSelect.getStringList(getInItems(), true, true) + ")" + (alias!=null?alias.toString():""); } }