Oracle Sql - Functions - Conversion

Front 1

Convert a character in any character set to an ASCII string

Back 1

ASCIISTR(x)

Front 2

Convert a binary number to a NUMBER

Back 2

BIN_TO_NUM(x)

Front 3

Convert a value to a compatible database type specified

Back 3

CAST(x AS type)

Front 4

Convert a value to type ROWID

Back 4

CHARTOROWID(x)

Front 5

Convert a value to a Unicode string in its fully normalized form in the same character set as the value

Back 5

COMPOSE(x)

Unicode uses a 2-bytecharacter set and can represent over 65,000 characters; sit may also be used to represent non-English characters

Front 6

Converts a value from one character set to another

Back 6

CONVERT(x,source_char_set,dest_char_set)

Front 7

Compare a value with another value in search. If equal return a specified value, otherwise return another specified value

Back 7

DECODE(x, search,result, default)

Compares x with the value in search; if equal, DECODE() returns the value in result; otherwise the value in default is returned.

Front 8

Convert a value to a Unicode string after decomposition of thestring into the same character set the value

Back 8

DECOMPOSE(x)

Front 9

Convert the character string containing hexadecimal digits(base-16) to a binary number (RAW) and return the RAW number

Back 9

HEXTORAW(x)

Front 10

Convert a number to an INTERVAL DAY TO SECOND

Back 10

NUMTODSINTERVAL(x)

Front 11

Convert a number to an INTERVAL YEAR TO MONTH

Back 11

NUMTOYMINTERVAL(x)

Front 12

Convert a binary number (RAW) to a VARCHAR2 string containing the equivalent hexadecimal number

Back 12

RAWTOHEX(x)

Front 13

Convert a binary number (RAW) to a NVARCHAR2 string containing the equivalent hexadecimal number

Back 13

RAWTONHEX(x)

(NVARCHAR2 stores a string using the national character set)

Front 14

Convert a ROWID to a VARCHAR2 string

Back 14

ROWIDTOCHAR(x)

Front 15

Convert a ROWID to an NVARCHAR2 string

Back 15

ROWIDTONCHAR(x)

Front 16

Convert a value to a BINARY_DOUBLE

Back 16

TO_BINARY_DOUBLE(x)

This function was introduced in Oracle Database 10g (with the datatype)

Front 17

Convert a value to a BINARY_FLOAT

Back 17

TO_BINARY_FLOAT(x)

This function was introduced in Oracle Database 10g (with the datatype)

Front 18

Convert a value to a binary large object (BLOB)

Back 18

TO_BLOB(x)

(A BLOB is usedto store large amounts of binary data)

Front 19

Convert a value to a VARCHAR2 string

Back 19

TO_CHAR(x [, format])

You can supply anoptional format that indicates the format of x.

Front 20

Convert a value to a character large object (CLOB)

Back 20

TO_CLOB(x)

(A CLOB isused to store large amounts of character data)

Front 21

Convert a value to a DATE

Back 21

TO_DATE(x [, format])

Front 22

Convert a string to an INTERVAL DAY TO SECOND

Back 22

TO_DSINTERVAL(x)

Front 23

Convert a value in the database character set to an NVARCHAR2string

Back 23

TO_NCHAR(x)

Front 24

Convert a value to a large object NCLOB

Back 24

TO_NCLOB(x)

(An NCLOB is used to store large amounts of national language character data)

Front 25

Convert a value to a NUMBER

Back 25

TO_NUMBER(x [, format])

Front 26

Convert the single-byte characters in a string to their corresponding multi-byte characters

Back 26

TO_MULTI_BYTE(x)

The return type is the same as the type for x

Front 27

Convert the multi-byte characters in a string to their corresponding single-byte characters

Back 27

TO_SINGLE_BYTE(x)

The return type is the same as the type for x

Front 28

Convert a string to a TIMESTAMP

Back 28

TO_TIMESTAMP(x)

Front 29

Convert a string to a TIMESTAMP WITH TIME ZONE

Back 29

TO_TIMESTAMP_TZ(x)

Front 30

Convert a string to an INTERVAL YEAR TO MONTH

Back 30

TO_YMINTERVAL(x)

Front 31

Convert all occurrences of a string from_string in string x to string to_string

Back 31

TRANSLATE(x,from_string,to_string)

Front 32

Convert the characters a string to an NCHAR characters

Back 32

UNISTR(x)

(NCHAR stores a character using the national languagecharacter set)

Front 33

Describe the behavior of: ASCIISTR()

Back 33

ASCIISTR(x)

Converts a character in any character set to an ASCII string

Front 34

Describe the behavior of: BIN_TO_NUM()

Back 34

BIN_TO_NUM(x)

Converts a binary number to a NUMBER

Front 35

Describe the behavior of: CAST()

Back 35

CAST(x AS type)

Converts a value to a compatible database type specified

Front 36

Describe the behavior of: CHARTOROWID()

Back 36

CHARTOROWID(x)

Converts a value to type ROWID

Front 37

Describe the behavior of: COMPOSE()

Back 37

COMPOSE(x)

Converts a value to a Unicode string in its fully normalized form in the same character set as the value

Unicode uses a 2-bytecharacter set and can represent over 65,000 characters; sit may also be used to represent non-English characters

Front 38

Describe the behavior of: CONVERT()

Back 38

CONVERT(x,source_char_set,dest_char_set)

Converts a value from one character set to another

Front 39

Describe the behavior of: DECODE()

Back 39

DECODE(x, search,result, default)

Compares x with the value in search; if equal, DECODE() returns the value in result; otherwise the value in default is returned

Front 40

Describe the behavior of: DECOMPOSE()

Back 40

DECOMPOSE(x)

Converts a value to a Unicode string after decomposition of thestring into the same character set the value

Front 41

Describe the behavior of: HEXTORAW()

Back 41

HEXTORAW(x)

Converts the character string containing hexadecimal digits(base-16) to a binary number (RAW) and returns the RAW number

Front 42

Describe the behavior of: NUMTODSINTERVAL()

Back 42

NUMTODSINTERVAL(x)

Converts a number to an INTERVAL DAY TO SECOND

Front 43

Describe the behavior of: NUMTOYMINTERVAL()

Back 43

NUMTOYMINTERVAL(x)

Converts a number to an INTERVAL YEAR TO MONTH

Front 44

Describe the behavior of: RAWTOHEX()

Back 44

RAWTOHEX(x)

Converts a binary number (RAW) to a VARCHAR2 string containing the equivalent hexadecimal number

Front 45

Describe the behavior of: RAWTONHEX()

Back 45

RAWTONHEX(x)

Converts a binary number (RAW) to a NVARCHAR2 string containing the equivalent hexadecimal number

(NVARCHAR2 stores a string using the national character set)

Front 46

Describe the behavior of: ROWIDTOCHAR()

Back 46

ROWIDTOCHAR()

Converts a ROWID to a VARCHAR2 string

Front 47

Describe the behavior of: ROWIDTONCHAR()

Back 47

ROWIDTONCHAR(x)

Converts a ROWID to an NVARCHAR2 string

Front 48

Describe the behavior of: TO_BINARY_DOUBLE()

Back 48

TO_BINARY_DOUBLE(x)

Converts a value to a BINARY_DOUBLE

This function was introduced in Oracle Database 10g (with the datatype)

Front 49

Describe the behavior of: TO_BINARY_FLOAT()

Back 49

TO_BINARY_FLOAT(x)

Converts a value to a BINARY_FLOAT

This function was introduced in Oracle Database 10g (with the datatype)

Front 50

Describe the behavior of: TO_BLOB()

Back 50

TO_BLOB(x)

Converts a value to a binary large object (BLOB)

(A BLOB is usedto store large amounts of binary data)

Front 51

Describe the behavior of: TO_CHAR()

Back 51

TO_CHAR(x [, format])

Converts a value to a VARCHAR2 string

You can supply anoptional format that indicates the format of x

Front 52

Describe the behavior of: TO_CLOB()

Back 52

TO_CLOB(x)

Converts a value to a character large object (CLOB)

(A CLOB isused to store large amounts of character data)

Front 53

Describe the behavior of: TO_DATE()

Back 53

TO_DATE(x [, format])

Converts a value to a DATE

Front 54

Describe the behavior of: TO_DSINTERVAL()

Back 54

TO_DSINTERVAL(x)

Convert a string to an INTERVAL DAY TO SECOND

Front 55

Describe the behavior of: TO_MULTI_BYTE()

Back 55

TO_MULTI_BYTE(x)

Converts the single-byte characters in a string to their corresponding multi-byte characters

The return type is the same as the type for x

Front 56

Describe the behavior of: TO_SINGLE_BYTE()

Back 56

TO_SINGLE_BYTE(x)

Converts the multi-byte characters in a string to their corresponding single-byte characters

The return type is the same as thetype for x

Front 57

Describe the behavior of: TO_NCHAR()

Back 57

TO_NCHAR(x)

Converts a value in the database character set to an NVARCHAR2string

Front 58

Describe the behavior of: TO_NCLOB()

Back 58

TO_NCLOB(x)

Converts a value to a large object NCLOB

(An NCLOB is used to store large amounts of national language character data)

Front 59

Describe the behavior of: TO_NUMBER()

Back 59

TO_NUMBER(x [, format])

Converts a value to a NUMBER

Front 60

Describe the behavior of: TO_TIMESTAMP()

Back 60

TO_TIMESTAMP(x)

Converts a string to a TIMESTAMP

Front 61

Describe the behavior of: TO_TIMESTAMP_TZ()

Back 61

TO_TIMESTAMP_TZ(x)

Converts a string to a TIMESTAMP WITH TIME ZONE

Front 62

Describe the behavior of: TO_YMINTERVAL()

Back 62

TO_YMINTERVAL(x)

Converts a string to an INTERVAL YEAR TO MONTH

Front 63

Describe the behavior of: TRANSLATE()

Back 63

TRANSLATE(x,from_string,to_string)

Convert all occurrences of a string from_string in string x to string to_string

Front 64

Describe the behavior of: UNISTR()

Back 64

UNISTR(x)

Convert the characters a string to an NCHAR characters

(NCHAR stores a character using the national languagecharacter set)