Oracle PL/SQL: BIN TO NUM - BIN TO NUM converts a bit vector to its equivalent number. Each argument to this function represents

Quick Search:

Oracle PL/SQL: BIN_TO_NUM

Jump to:

Category: >> Oracle PL/SQL >> BIN_TO_NUM

<< last

next >>

Snippet Name: BIN_TO_NUM

Description: BIN_TO_NUM converts a bit vector to its equivalent number. Each argument to this function represents a bit in the bit vector. This function takes as arguments any numeric datatype, or any nonnumeric datatype that can be implicitly converted to NUMBER. Each expr must evaluate to 0 or 1. This function returns Oracle NUMBER.

BIN_TO_NUM is useful in data warehousing applications for selecting groups of interest from a materialized view using grouping sets.

Also see:
» Add PSOUG Search to SQL Developer
» Converting Rows to Columns
» UNISTR
» TRANSLATE
» TO_YMINTERVAL
» TO_TIMESTAMP_TZ
» TO_TIMESTAMP
» TO_SINGLE_BYTE
» TO_NUMBER
» TO_NCLOB
» TO_NCHAR
» TO_MULTI_BYTE
» TO_LOB
» TO_DSINTERVAL
» TO_DATE
» TO_CLOB
» TO_CHAR
» TO_BINARY_FLOAT
» TO_BINARY_DOUBLE
» TIMESTAMP_TO_SCN
» SCN_TO_TIMESTAMP
» ROWIDTONCHAR
» ROWIDTOCHAR
» REFTOHEX
» RAWTONHEX
» RAWTOHEX
» NUMTOYMINTERVAL
» NUMTODSINTERVAL
» HEXTORAW
» DECOMPOSE

Comment: (none)

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 05th, 2009

BIN_TO_NUM(<value>,<value>,....)
 
-- The following example converts a binary value to a number:
 
SELECT BIN_TO_NUM(1,0,1,0) FROM DUAL; 
 
BIN_TO_NUM(1,0,1,0)
-------------------
                 10