Class OracleDSL

    • Constructor Detail

      • OracleDSL

        protected OracleDSL()
        No instances
    • Method Detail

      • rownum

        @Support(ORACLE)
        public static Field<java.lang.Integer> rownum()
        The Oracle-specific ROWNUM pseudo-field.
      • rowid

        @Support(ORACLE)
        public static Field<java.lang.String> rowid()
        The Oracle-specific ROWID pseudo-field.
      • rowscn

        @Support(ORACLE)
        public static Field<java.lang.Long> rowscn()
        The Oracle-specific ORA_ROWSCN pseudo-field.
      • oraRowscn

        @Support(ORACLE)
        public static Field<java.lang.Long> oraRowscn()
        The Oracle-specific ORA_ROWSCN pseudo-field.
      • scnToTimestamp

        @Support(ORACLE)
        public static Field<java.sql.Timestamp> scnToTimestamp​(java.lang.Number scn)
        The Oracle-specific SCN_TO_TIMESTAMP function.
      • scnToTimestamp

        @Support(ORACLE)
        public static Field<java.sql.Timestamp> scnToTimestamp​(Field<? extends java.lang.Number> scn)
        The Oracle-specific SCN_TO_TIMESTAMP function.
      • timestampToScn

        @Support(ORACLE)
        public static Field<java.lang.Long> timestampToScn​(java.util.Date timestamp)
        The Oracle-specific TIMESTAMP_TO_SCN function.
      • timestampToScn

        @Support(ORACLE)
        public static Field<java.lang.Long> timestampToScn​(Field<? extends java.util.Date> scn)
        The Oracle-specific TIMESTAMP_TO_SCN function.
      • sysContext

        @Support(ORACLE)
        public static Field<java.lang.String> sysContext​(java.lang.String namespace,
                                                         java.lang.String parameter)
        The Oracle-specific SYS_CONTEXT function.
      • sysContext

        @Support(ORACLE)
        public static Field<java.lang.String> sysContext​(java.lang.String namespace,
                                                         java.lang.String parameter,
                                                         int length)
        The Oracle-specific SYS_CONTEXT function.
      • toChar

        @Support(ORACLE)
        public static Field<java.lang.String> toChar​(java.lang.Object value)
        The Oracle-specific TO_CHAR function.
      • toChar

        @Support(ORACLE)
        public static Field<java.lang.String> toChar​(Field<?> value)
        The Oracle-specific TO_CHAR function.
      • toChar

        @Support(ORACLE)
        public static Field<java.lang.String> toChar​(java.lang.Object value,
                                                     java.lang.String formatMask)
        The Oracle-specific TO_CHAR function.
      • toChar

        @Support(ORACLE)
        public static Field<java.lang.String> toChar​(java.lang.Object value,
                                                     Field<java.lang.String> formatMask)
        The Oracle-specific TO_CHAR function.
      • toChar

        @Support(ORACLE)
        public static Field<java.lang.String> toChar​(Field<?> value,
                                                     java.lang.String formatMask)
        The Oracle-specific TO_CHAR function.
      • toChar

        @Support(ORACLE)
        public static Field<java.lang.String> toChar​(Field<?> value,
                                                     Field<java.lang.String> formatMask)
        The Oracle-specific TO_CHAR function.
      • toNumber

        @Support(ORACLE)
        public static Field<java.math.BigDecimal> toNumber​(java.lang.String value)
        The Oracle-specific TO_NUMBER function.
      • toNumber

        @Support(ORACLE)
        public static Field<java.math.BigDecimal> toNumber​(Field<java.lang.String> value)
        The Oracle-specific TO_NUMBER function.
      • toNumber

        @Support(ORACLE)
        public static Field<java.math.BigDecimal> toNumber​(java.lang.String value,
                                                           java.lang.String formatMask)
        The Oracle-specific TO_NUMBER function.
      • toNumber

        @Support(ORACLE)
        public static Field<java.math.BigDecimal> toNumber​(java.lang.String value,
                                                           Field<java.lang.String> formatMask)
        The Oracle-specific TO_NUMBER function.
      • toNumber

        @Support(ORACLE)
        public static Field<java.math.BigDecimal> toNumber​(Field<java.lang.String> value,
                                                           java.lang.String formatMask)
        The Oracle-specific TO_NUMBER function.
      • toNumber

        @Support(ORACLE)
        public static Field<java.math.BigDecimal> toNumber​(Field<java.lang.String> value,
                                                           Field<java.lang.String> formatMask)
        The Oracle-specific TO_NUMBER function.
      • versionsStartscn

        @Support(ORACLE)
        public static Field<java.lang.Long> versionsStartscn()
        The Oracle-specific VERSIONS_STARTSCN pseudo-field.
      • versionsStarttime

        @Support(ORACLE)
        public static Field<java.sql.Timestamp> versionsStarttime()
        The Oracle-specific VERSIONS_STARTTIME pseudo-field.
      • versionsEndscn

        @Support(ORACLE)
        public static Field<java.lang.Long> versionsEndscn()
        The Oracle-specific VERSIONS_ENDSCN pseudo-field.
      • versionsEndtime

        @Support(ORACLE)
        public static Field<java.sql.Timestamp> versionsEndtime()
        The Oracle-specific VERSIONS_ENDTIME pseudo-field.
      • versionsXid

        @Support(ORACLE)
        public static Field<java.lang.String> versionsXid()
        The Oracle-specific VERSIONS_XID pseudo-field.
      • versionsOperation

        @Support(ORACLE)
        public static Field<java.lang.String> versionsOperation()
        The Oracle-specific VERSIONS_OPERATION pseudo-field.
      • contains

        @Support(ORACLE)
        public static Field<java.math.BigDecimal> contains​(Field<java.lang.String> field,
                                                           java.lang.String query)
        The Oracle-Text specific CONTAINS function.
      • contains

        @Support(ORACLE)
        public static Field<java.math.BigDecimal> contains​(Field<java.lang.String> field,
                                                           java.lang.String query,
                                                           int label)
        The Oracle-Text specific CONTAINS function.
      • matches

        @Support(ORACLE)
        public static Field<java.math.BigDecimal> matches​(Field<java.lang.String> field,
                                                          java.lang.String query)
        The Oracle-Text specific MATCHES function.
      • matches

        @Support(ORACLE)
        public static Field<java.math.BigDecimal> matches​(Field<java.lang.String> field,
                                                          java.lang.String query,
                                                          int label)
        The Oracle-Text specific CONTAINS function.
      • catsearch

        @Support(ORACLE)
        public static Field<java.math.BigDecimal> catsearch​(Field<java.lang.String> field,
                                                            java.lang.String textQuery,
                                                            java.lang.String structuredQuery)
        The Oracle-Text specific CATSEARCH function.
      • score

        @Support(ORACLE)
        public static Field<java.math.BigDecimal> score​(int label)
        The Oracle-Text specific SCORE function.
      • matchScore

        @Support(ORACLE)
        public static Field<java.math.BigDecimal> matchScore​(int label)
        The Oracle-Text specific MATCH_SCORE function.