com.esri.arcgis.geodatabase
Interface esriSQLFunctionName

All Superinterfaces:

Serializable

public interface esriSQLFunctionName
extends Serializable

SQL Functions.

Product Availability

Available with ArcGIS Engine, ArcGIS Desktop, and ArcGIS Server.

Supported Platforms

Windows, Solaris, Linux

Field Summary

static int	esriSQL_ABS SQL ABS.
static int	esriSQL_ACOS SQL ACOS.
static int	esriSQL_ASCII SQL ASCII.
static int	esriSQL_ASIN SQL ASIN.
static int	esriSQL_ATAN SQL ATAN.
static int	esriSQL_AVG SQL AVG.
static int	esriSQL_BITLENGTH SQL BITLENGTH.
static int	esriSQL_CAST SQL CAST.
static int	esriSQL_CEILING SQL CEILING.
static int	esriSQL_CHAR SQL CHAR.
static int	esriSQL_CHARLENGTH SQL CHARLENGTH.
static int	esriSQL_COALESCE SQL COALESCE.
static int	esriSQL_CONCAT SQL CONCAT.
static int	esriSQL_CONVERT SQL CONVERT.
static int	esriSQL_COS SQL COS.
static int	esriSQL_COSH SQL COSH.
static int	esriSQL_COUNT SQL COUNT.
static int	esriSQL_CURRENTDATE SQL CURRENTDATE.
static int	esriSQL_CURRENTTIME SQL CURRENTTIME.
static int	esriSQL_CURRENTTIMESTAMP SQL CURRENTTIMESTAMP.
static int	esriSQL_CURRENTUSER SQL CURRENTUSER.
static int	esriSQL_EXTRACT SQL EXTRACT.
static int	esriSQL_FLOOR SQL FLOOR.
static int	esriSQL_HEX SQL HEX.
static int	esriSQL_LEADING SQL LEADING.
static int	esriSQL_LN SQL LN.
static int	esriSQL_LOG SQL LOG.
static int	esriSQL_LOG10 SQL LOG10.
static int	esriSQL_LOWER SQL LOWER.
static int	esriSQL_MAX SQL MAX.
static int	esriSQL_MIN SQL MIN.
static int	esriSQL_MOD SQL MOD.
static int	esriSQL_NULLIF SQL NULLIF.
static int	esriSQL_OCTETLENGTH SQL OCTETLENGTH.
static int	esriSQL_POSITION SQL POSITION.
static int	esriSQL_POWER SQL POWER.
static int	esriSQL_ROUND SQL ROUND.
static int	esriSQL_SIGN SQL SIGN.
static int	esriSQL_SIN SQL SIN.
static int	esriSQL_SINH SQL SINH.
static int	esriSQL_SOUNDEX SQL SOUNDEX.
static int	esriSQL_STDDEV SQL Standard Deviation.
static int	esriSQL_STDDEV_POP SQL STDDEV_POP.
static int	esriSQL_STDDEV_SAMP SQL STDDEV_SAMP.
static int	esriSQL_SUBSTRING SQL SUBSTRING.
static int	esriSQL_SUBSTRINGBYTES SQL SUBSTRING Bytes.
static int	esriSQL_SUM SQL SUM.
static int	esriSQL_TAN SQL TAN.
static int	esriSQL_TANH SQL TANH.
static int	esriSQL_TRAILING SQL TRAILING.
static int	esriSQL_TRANSLATE SQL TRANSLATE.
static int	esriSQL_TRIM SQL TRIM.
static int	esriSQL_TRUNCATE SQL TRUNCATE.
static int	esriSQL_UPPER SQL UPPER.
static int	esriSQL_VAR SQL VAR.
static int	esriSQL_VAR_POP SQL VAR_POP.
static int	esriSQL_VAR_SAMP SQL VAR_SAMP.

Field Detail

esriSQL_MIN

static final int esriSQL_MIN

SQL MIN.

See Also:

Constant Field Values

esriSQL_MAX

static final int esriSQL_MAX

SQL MAX.

See Also:

Constant Field Values

esriSQL_COUNT

static final int esriSQL_COUNT

SQL COUNT.

See Also:

Constant Field Values

esriSQL_SUM

static final int esriSQL_SUM

SQL SUM.

See Also:

Constant Field Values

esriSQL_AVG

static final int esriSQL_AVG

SQL AVG.

See Also:

Constant Field Values

esriSQL_VAR

static final int esriSQL_VAR

SQL VAR.

See Also:

Constant Field Values

esriSQL_STDDEV

static final int esriSQL_STDDEV

SQL Standard Deviation.

See Also:

Constant Field Values

esriSQL_CONCAT

static final int esriSQL_CONCAT

SQL CONCAT.

See Also:

Constant Field Values

esriSQL_LEADING

static final int esriSQL_LEADING

SQL LEADING.

See Also:

Constant Field Values

esriSQL_LOWER

static final int esriSQL_LOWER

SQL LOWER.

See Also:

Constant Field Values

esriSQL_TRAILING

static final int esriSQL_TRAILING

SQL TRAILING.

See Also:

Constant Field Values

esriSQL_SUBSTRING

static final int esriSQL_SUBSTRING

SQL SUBSTRING.

See Also:

Constant Field Values

esriSQL_SUBSTRINGBYTES

static final int esriSQL_SUBSTRINGBYTES

SQL SUBSTRING Bytes.

See Also:

Constant Field Values

esriSQL_UPPER

static final int esriSQL_UPPER

SQL UPPER.

See Also:

Constant Field Values

esriSQL_ASCII

static final int esriSQL_ASCII

SQL ASCII.

See Also:

Constant Field Values

esriSQL_CHAR

static final int esriSQL_CHAR

SQL CHAR.

See Also:

Constant Field Values

esriSQL_SOUNDEX

static final int esriSQL_SOUNDEX

SQL SOUNDEX.

See Also:

Constant Field Values

esriSQL_TRANSLATE

static final int esriSQL_TRANSLATE

SQL TRANSLATE.

See Also:

Constant Field Values

esriSQL_TRIM

static final int esriSQL_TRIM

SQL TRIM.

See Also:

Constant Field Values

esriSQL_ABS

static final int esriSQL_ABS

SQL ABS.

See Also:

Constant Field Values

esriSQL_ACOS

static final int esriSQL_ACOS

SQL ACOS.

See Also:

Constant Field Values

esriSQL_ASIN

static final int esriSQL_ASIN

SQL ASIN.

See Also:

Constant Field Values

esriSQL_ATAN

static final int esriSQL_ATAN

SQL ATAN.

See Also:

Constant Field Values

esriSQL_CEILING

static final int esriSQL_CEILING

SQL CEILING.

See Also:

Constant Field Values

esriSQL_COS

static final int esriSQL_COS

SQL COS.

See Also:

Constant Field Values

esriSQL_FLOOR

static final int esriSQL_FLOOR

SQL FLOOR.

See Also:

Constant Field Values

esriSQL_LOG

static final int esriSQL_LOG

SQL LOG.

See Also:

Constant Field Values

esriSQL_LN

static final int esriSQL_LN

SQL LN.

See Also:

Constant Field Values

esriSQL_MOD

static final int esriSQL_MOD

SQL MOD.

See Also:

Constant Field Values

esriSQL_SIGN

static final int esriSQL_SIGN

SQL SIGN.

See Also:

Constant Field Values

esriSQL_SIN

static final int esriSQL_SIN

SQL SIN.

See Also:

Constant Field Values

esriSQL_TAN

static final int esriSQL_TAN

SQL TAN.

See Also:

Constant Field Values

esriSQL_LOG10

static final int esriSQL_LOG10

SQL LOG10.

See Also:

Constant Field Values

esriSQL_POWER

static final int esriSQL_POWER

SQL POWER.

See Also:

Constant Field Values

esriSQL_ROUND

static final int esriSQL_ROUND

SQL ROUND.

See Also:

Constant Field Values

esriSQL_TRUNCATE

static final int esriSQL_TRUNCATE

SQL TRUNCATE.

See Also:

Constant Field Values

esriSQL_SINH

static final int esriSQL_SINH

SQL SINH.

See Also:

Constant Field Values

esriSQL_COSH

static final int esriSQL_COSH

SQL COSH.

See Also:

Constant Field Values

esriSQL_TANH

static final int esriSQL_TANH

SQL TANH.

See Also:

Constant Field Values

esriSQL_HEX

static final int esriSQL_HEX

SQL HEX.

See Also:

Constant Field Values

esriSQL_EXTRACT

static final int esriSQL_EXTRACT

SQL EXTRACT.

See Also:

Constant Field Values

esriSQL_BITLENGTH

static final int esriSQL_BITLENGTH

SQL BITLENGTH.

See Also:

Constant Field Values

esriSQL_CHARLENGTH

static final int esriSQL_CHARLENGTH

SQL CHARLENGTH.

See Also:

Constant Field Values

esriSQL_OCTETLENGTH

static final int esriSQL_OCTETLENGTH

SQL OCTETLENGTH.

See Also:

Constant Field Values

esriSQL_POSITION

static final int esriSQL_POSITION

SQL POSITION.

See Also:

Constant Field Values

esriSQL_CURRENTDATE

static final int esriSQL_CURRENTDATE

SQL CURRENTDATE.

See Also:

Constant Field Values

esriSQL_CURRENTTIME

static final int esriSQL_CURRENTTIME

SQL CURRENTTIME.

See Also:

Constant Field Values

esriSQL_CURRENTUSER

static final int esriSQL_CURRENTUSER

SQL CURRENTUSER.

See Also:

Constant Field Values

esriSQL_COALESCE

static final int esriSQL_COALESCE

SQL COALESCE.

See Also:

Constant Field Values

esriSQL_CONVERT

static final int esriSQL_CONVERT

SQL CONVERT.

See Also:

Constant Field Values

esriSQL_CAST

static final int esriSQL_CAST

SQL CAST.

See Also:

Constant Field Values

esriSQL_CURRENTTIMESTAMP

static final int esriSQL_CURRENTTIMESTAMP

SQL CURRENTTIMESTAMP.

See Also:

Constant Field Values

esriSQL_NULLIF

static final int esriSQL_NULLIF

SQL NULLIF.

See Also:

Constant Field Values

esriSQL_VAR_SAMP

static final int esriSQL_VAR_SAMP

SQL VAR_SAMP.

See Also:

Constant Field Values

esriSQL_VAR_POP

static final int esriSQL_VAR_POP

SQL VAR_POP.

See Also:

Constant Field Values

esriSQL_STDDEV_SAMP

static final int esriSQL_STDDEV_SAMP

SQL STDDEV_SAMP.

See Also:

Constant Field Values

esriSQL_STDDEV_POP

static final int esriSQL_STDDEV_POP

SQL STDDEV_POP.

See Also:

Constant Field Values