Enum CorrelateJoinType

  • All Implemented Interfaces:
    java.io.Serializable, java.lang.Comparable<CorrelateJoinType>

    public enum CorrelateJoinType
    extends java.lang.Enum<CorrelateJoinType>
    Specifies the type of correlation operation: inner, left, semi, or anti.
    • Enum Constant Summary

      Enum Constants 
      Enum Constant Description
      ANTI
      Anti-join.
      INNER
      Inner join
      LEFT
      Left-outer join
      SEMI
      Semi-join.
    • Constructor Summary

      Constructors 
      Modifier Constructor Description
      private CorrelateJoinType()  
    • Method Summary

      All Methods Static Methods Concrete Methods 
      Modifier and Type Method Description
      static CorrelateJoinType valueOf​(java.lang.String name)
      Returns the enum constant of this type with the specified name.
      static CorrelateJoinType[] values()
      Returns an array containing the constants of this enum type, in the order they are declared.
      • Methods inherited from class java.lang.Enum

        clone, compareTo, equals, finalize, getDeclaringClass, hashCode, name, ordinal, toString, valueOf
      • Methods inherited from class java.lang.Object

        getClass, notify, notifyAll, wait, wait, wait
    • Enum Constant Detail

      • SEMI

        public static final CorrelateJoinType SEMI
        Semi-join.

        Similar to from A ... where a in (select b from B ...)

      • ANTI

        public static final CorrelateJoinType ANTI
        Anti-join.

        Similar to from A ... where a NOT in (select b from B ...)

        Note: if B.b is nullable and B has nulls, no rows must be returned.

    • Constructor Detail

      • CorrelateJoinType

        private CorrelateJoinType()
    • Method Detail

      • values

        public static CorrelateJoinType[] values()
        Returns an array containing the constants of this enum type, in the order they are declared. This method may be used to iterate over the constants as follows:
        for (CorrelateJoinType c : CorrelateJoinType.values())
            System.out.println(c);
        
        Returns:
        an array containing the constants of this enum type, in the order they are declared
      • valueOf

        public static CorrelateJoinType valueOf​(java.lang.String name)
        Returns the enum constant of this type with the specified name. The string must match exactly an identifier used to declare an enum constant in this type. (Extraneous whitespace characters are not permitted.)
        Parameters:
        name - the name of the enum constant to be returned.
        Returns:
        the enum constant with the specified name
        Throws:
        java.lang.IllegalArgumentException - if this enum type has no constant with the specified name
        java.lang.NullPointerException - if the argument is null