Friday, October 28, 2011
ORACLE SQL TUTORIAL: CONVERSION FUNCTIONS
CONVERSION
FUNCTIONS
Ø Bin_to_num
Ø Chartorowid
Ø Rowidtochar
Ø To_number
Ø To_char
Ø To_date
a) BIN_TO_NUM
This will convert the binary value to its
numerical equivalent.
Syntax: bin_to_num( binary_bits)
Ex:
SQL> select bin_to_num(1,1,0) from
dual;
BIN_TO_NUM(1,1,0)
------------------------
6
Ø If all the bits are zero then it produces zero.
Ø If all the bits are null then it produces an error.
b) CHARTOROWID
This will convert a character string to
act like an internal oracle row identifier or rowid.
c) ROWIDTOCHAR
This will convert an internal oracle row
identifier or rowid to character string.
d) TO_NUMBER
This will convert a char or varchar to
number.
e) TO_CHAR
This will convert a number or date to
character string.
f) TO_DATE
This will convert a number, char or varchar
to a date.
Do you think this Article is useful?
Subscribe to:
Post Comments (Atom)
0 Responses to “ORACLE SQL TUTORIAL: CONVERSION FUNCTIONS”
Post a Comment