Posted By

bbrumm on 03/27/17

Tagged

sql Oracle

Viewed 2 times

Oracle BIN_TO_NUM Function


/ Published in: SQL

URL: http://www.databasestar.com/oracle-bin_to_num

A few examples of the BIN_TO_NUM function.

  1. SELECT BIN_TO_NUM(1) AS "bin_to_num"
  2. FROM dual;
  3.  
  4.  
  5. SELECT BIN_TO_NUM(1, 0) AS "bin_to_num"
  6. FROM dual;
  7.  
  8.  
  9. SELECT
  10. BIN_TO_NUM(1, 1) AS two_values,
  11. BIN_TO_NUM(1, 0, 1) AS three_values,
  12. BIN_TO_NUM(1, 1, 0, 1) AS four_values,
  13. BIN_TO_NUM(1, 0, 0, 1, 1, 1, 0, 1) AS eight_values
  14. FROM dual;

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.