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