Thursday, August 12, 2010

String Functions

Do Any body know How many of String Function We have. Be familiar whith these it will be very help full while writing the Programs.
ascii
blob_to_string
blob_to_string_output
chr
initcap
isblob
isstring
lcase
left
length
locate
ltrim
make_string
regexp_instr
regexp_like
regexp_match
regexp_parse
regexp_replace
regexp_substr
repeat
replace
right
rtrim
search_excerpt
serialize
space
split_and_decode
sprintf
sprintf_inverse
sprintf_iri
sprintf_iri_or_null
sprintf_or_null
strcasestr
strchr
string_output
string_output_flush
string_output_gz_compress
string_output_string
string_to_file
strrchr
strstr
subseq
substring
tmp_file_name
trim
ucase
upper

9 comments:

  1. Numaric Functions :

    ABS
    ACOS
    ASIN
    ATAN
    ATAN2
    BITAND
    CEIL
    COS
    COSH
    EXP
    FLOOR
    LN
    LOG
    MOD
    NANVL
    POWER
    REMAINDER
    ROUND (number)
    SIGN
    SIN
    SINH
    SQRT
    TAN
    TANH
    TRUNC (number)
    WIDTH_BUCKET

    ReplyDelete
  2. Date Functions:

    ADD_MONTHS
    CURRENT_DATE
    CURRENT_TIMESTAMP
    DBTIMEZONE
    EXTRACT (datetime)
    FROM_TZ
    LAST_DAY
    LOCALTIMESTAMP
    MONTHS_BETWEEN
    NEW_TIME
    NEXT_DAY
    NUMTODSINTERVAL
    NUMTOYMINTERVAL
    ROUND (date)
    SESSIONTIMEZONE
    SYS_EXTRACT_UTC
    SYSDATE
    SYSTIMESTAMP
    TO_CHAR (datetime)
    TO_TIMESTAMP
    TO_TIMESTAMP_TZ
    TO_DSINTERVAL
    TO_YMINTERVAL
    TRUNC (date)
    TZ_OFFSET

    ReplyDelete
  3. Conversion Functions:
    ASCIISTR
    BIN_TO_NUM
    CAST
    CHARTOROWID
    COMPOSE
    CONVERT
    DECOMPOSE
    HEXTORAW
    NUMTODSINTERVAL
    NUMTOYMINTERVAL
    RAWTOHEX
    RAWTONHEX
    ROWIDTOCHAR
    ROWIDTONCHAR
    SCN_TO_TIMESTAMP
    TIMESTAMP_TO_SCN
    TO_BINARY_DOUBLE
    TO_BINARY_FLOAT
    TO_CHAR (character)
    TO_CHAR (datetime)
    TO_CHAR (number)
    TO_CLOB
    TO_DATE
    TO_DSINTERVAL
    TO_LOB
    TO_MULTI_BYTE
    TO_NCHAR (character)
    TO_NCHAR (datetime)
    TO_NCHAR (number)
    TO_NCLOB
    TO_NUMBER
    TO_DSINTERVAL
    TO_SINGLE_BYTE
    TO_TIMESTAMP
    TO_TIMESTAMP_TZ
    TO_YMINTERVAL
    TO_YMINTERVAL
    TRANSLATE ... USING
    UNISTR

    ReplyDelete
  4. Collection Functions:
    CARDINALITY
    COLLECT
    POWERMULTISET
    POWERMULTISET_BY_CARDINALITY
    SET

    ReplyDelete
  5. Miscellaneous Single-Row Functions:

    BFILENAME
    COALESCE
    CV
    DECODE
    DEPTH
    DUMP
    EMPTY_BLOB, EMPTY_CLOB
    EXISTSNODE
    EXTRACT (XML)
    EXTRACTVALUE
    GREATEST
    LEAST
    LNNVL
    NLS_CHARSET_DECL_LEN
    NLS_CHARSET_ID
    NLS_CHARSET_NAME
    NULLIF
    NVL
    NVL2
    ORA_HASH
    PATH
    PRESENTNNV
    PRESENTV
    PREVIOUS
    SYS_CONNECT_BY_PATH
    SYS_CONTEXT
    SYS_DBURIGEN
    SYS_EXTRACT_UTC
    SYS_GUID
    SYS_TYPEID
    SYS_XMLAGG
    SYS_XMLGEN
    UID
    UPDATEXML
    USER
    USERENV
    VSIZE
    XMLAGG
    XMLCOLATTVAL
    XMLCONCAT
    XMLFOREST
    XMLSEQUENCE
    XMLTRANSFORM

    ReplyDelete
  6. Aggreate Functions:

    AVG
    COLLECT
    CORR
    CORR_*
    COUNT
    COVAR_POP
    COVAR_SAMP
    CUME_DIST
    DENSE_RANK
    FIRST
    GROUP_ID
    GROUPING
    GROUPING_ID
    LAST
    MAX
    MEDIAN
    MIN
    PERCENTILE_CONT
    PERCENTILE_DISC
    PERCENT_RANK
    RANK
    REGR_ (Linear Regression) Functions
    STATS_BINOMIAL_TEST
    STATS_CROSSTAB
    STATS_F_TEST
    STATS_KS_TEST
    STATS_MODE
    STATS_MW_TEST
    STATS_ONE_WAY_ANOVA
    STATS_T_TEST_*
    STATS_WSR_TEST
    STDDEV
    STDDEV_POP
    STDDEV_SAMP
    SUM
    VAR_POP
    VAR_SAMP
    VARIANCE

    ReplyDelete
  7. Analytic Functions:

    AVG *
    CORR *
    COVAR_POP *
    COVAR_SAMP *
    COUNT *
    CUME_DIST
    DENSE_RANK
    FIRST
    FIRST_VALUE *
    LAG
    LAST
    LAST_VALUE *
    LEAD
    MAX *
    MIN *
    NTILE
    PERCENT_RANK
    PERCENTILE_CONT
    PERCENTILE_DISC
    RANK
    RATIO_TO_REPORT
    REGR_ (Linear Regression) Functions *
    ROW_NUMBER
    STDDEV *
    STDDEV_POP *
    STDDEV_SAMP *
    SUM *
    VAR_POP *
    VAR_SAMP *
    VARIANCE *

    ReplyDelete
  8. Object Reference Functions:

    DEREF
    MAKE_REF
    REF
    REFTOHEX
    VALUE

    ReplyDelete
  9. Model Functions :

    Model functions are relevant only for interrow calculations and can be used only in the model_clause of the SELECT statement. They are nonrecursive. The model functions are:


    CV
    ITERATION_NUMBER
    PRESENTNNV
    PRESENTV
    PREVIOUS

    ReplyDelete