@Override public void visit( ScalarSubquery obj ) { if (obj.getSubqueryHint().isDepJoin() || obj.getSubqueryHint().isMergeJoin() || obj.getSubqueryHint().isNoUnnest()) { if (this.parts.length() > 0 && this.parts.charAt(this.parts.length()-1) == ' ') { this.parts.setLength(this.parts.length() -1); } addSubqueryHint(obj.getSubqueryHint()); append(SPACE); } append("("); //$NON-NLS-1$ visitNode(obj.getCommand()); append(")"); //$NON-NLS-1$ }
@Override public void visit( ScalarSubquery obj ) { if (obj.getSubqueryHint().isDepJoin() || obj.getSubqueryHint().isMergeJoin() || obj.getSubqueryHint().isNoUnnest()) { if (this.parts.length() > 0 && this.parts.charAt(this.parts.length()-1) == ' ') { this.parts.setLength(this.parts.length() -1); } addSubqueryHint(obj.getSubqueryHint()); append(SPACE); } append("("); //$NON-NLS-1$ visitNode(obj.getCommand()); append(")"); //$NON-NLS-1$ }
@Override public void visit( ScalarSubquery obj ) { if (obj.getSubqueryHint().isDepJoin() || obj.getSubqueryHint().isMergeJoin() || obj.getSubqueryHint().isNoUnnest()) { if (this.parts.length() > 0 && this.parts.charAt(this.parts.length()-1) == ' ') { this.parts.setLength(this.parts.length() -1); } addSubqueryHint(obj.getSubqueryHint()); append(SPACE); } append("("); //$NON-NLS-1$ visitNode(obj.getCommand()); append(")"); //$NON-NLS-1$ }
@Override public void visit( ExistsCriteria obj ) { if (obj.isNegated()) { append(NOT); append(SPACE); } append(EXISTS); addSubqueryHint(obj.getSubqueryHint()); append(" ("); //$NON-NLS-1$ visitNode(obj.getCommand()); append(")"); //$NON-NLS-1$ }
@Override public void visit( ExistsCriteria obj ) { if (obj.isNegated()) { append(NOT); append(SPACE); } append(EXISTS); addSubqueryHint(obj.getSubqueryHint()); append(" ("); //$NON-NLS-1$ visitNode(obj.getCommand()); append(")"); //$NON-NLS-1$ }
@Override public void visit( ExistsCriteria obj ) { if (obj.isNegated()) { append(NOT); append(SPACE); } append(EXISTS); addSubqueryHint(obj.getSubqueryHint()); append(" ("); //$NON-NLS-1$ visitNode(obj.getCommand()); append(")"); //$NON-NLS-1$ }
@Override public void visit( SubquerySetCriteria obj ) { // variable visitNode(obj.getExpression()); // operator and beginning of list append(SPACE); if (obj.isNegated()) { append(NOT); append(SPACE); } append(IN); addSubqueryHint(obj.getSubqueryHint()); append(" ("); //$NON-NLS-1$ visitNode(obj.getCommand()); append(")"); //$NON-NLS-1$ }
@Override public void visit( SubquerySetCriteria obj ) { // variable visitNode(obj.getExpression()); // operator and beginning of list append(SPACE); if (obj.isNegated()) { append(NOT); append(SPACE); } append(IN); addSubqueryHint(obj.getSubqueryHint()); append(" ("); //$NON-NLS-1$ visitNode(obj.getCommand()); append(")"); //$NON-NLS-1$ }
@Override public void visit( SubquerySetCriteria obj ) { // variable visitNode(obj.getExpression()); // operator and beginning of list append(SPACE); if (obj.isNegated()) { append(NOT); append(SPACE); } append(IN); addSubqueryHint(obj.getSubqueryHint()); append(" ("); //$NON-NLS-1$ visitNode(obj.getCommand()); append(")"); //$NON-NLS-1$ }
@Override public void visit( SubqueryCompareCriteria obj ) { Expression leftExpression = obj.getLeftExpression(); visitNode(leftExpression); String operator = obj.getOperatorAsString(); String quantifier = obj.getPredicateQuantifierAsString(); // operator and beginning of list append(SPACE); append(operator); append(SPACE); append(quantifier); addSubqueryHint(obj.getSubqueryHint()); append(" ("); //$NON-NLS-1$ if (obj.getCommand() != null) { visitNode(obj.getCommand()); } else { visitNode(obj.getArrayExpression()); } append(")"); //$NON-NLS-1$ }
@Override public void visit( SubqueryCompareCriteria obj ) { Expression leftExpression = obj.getLeftExpression(); visitNode(leftExpression); String operator = obj.getOperatorAsString(); String quantifier = obj.getPredicateQuantifierAsString(); // operator and beginning of list append(SPACE); append(operator); append(SPACE); append(quantifier); addSubqueryHint(obj.getSubqueryHint()); append(" ("); //$NON-NLS-1$ if (obj.getCommand() != null) { visitNode(obj.getCommand()); } else { visitNode(obj.getArrayExpression()); } append(")"); //$NON-NLS-1$ }
@Override public void visit( SubqueryCompareCriteria obj ) { Expression leftExpression = obj.getLeftExpression(); visitNode(leftExpression); String operator = obj.getOperatorAsString(); String quantifier = obj.getPredicateQuantifierAsString(); // operator and beginning of list append(SPACE); append(operator); append(SPACE); append(quantifier); addSubqueryHint(obj.getSubqueryHint()); append(" ("); //$NON-NLS-1$ if (obj.getCommand() != null) { visitNode(obj.getCommand()); } else { visitNode(obj.getArrayExpression()); } append(")"); //$NON-NLS-1$ }