CONVERSION FUNCTIONS

BIN_TO_NUM

This will convert the binary value to its numerical equivalent

Syntax

bin_to_num( binary_bits)

SQL> select bin_to_num(1,1,0) from dual;

BIN_TO_NUM(1,1,0)

————————

1 If all the bits are zero then it produces zero.

2 If all the bits are null then it produces an error.

CHARTOROWID

This will convert a character string to act like an internal oracle row identifier or rowid.

This will convert an internal oracle row identifier or rowid to character string

This will convert a char or varchar to number.

This will convert a number or date to character string

This will convert a number, char or varchar to a date