Friday, October 28, 2011
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;
Ø If all the bits are zero then it produces zero.
Ø If all the bits are null then it produces an error.
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.
Do you think this Article is useful?
The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.