Oracle in a Nutshell

Calls

FUNCTION UTL_RAW.BIT_AND (r1 IN RAW, r2 IN RAW) RETURN RAW;

Returns the bitwise logical AND of r1 and r2.

FUNCTION UTL_RAW.BIT_COMPLEMENT (r1 IN RAW, r2 IN RAW) RETURN RAW;

Returns the bitwise logical complement of r1 and r2.

FUNCTION UTL_RAW.BIT_OR (r1 IN RAW, r2 IN RAW) RETURN RAW;

Returns the bitwise logical OR of r1 and r2.

FUNCTION UTL_RAW.BIT_XOR (r1 IN RAW, r2 IN RAW) RETURN RAW;

Returns the bitwise logical XOR of r1 and r2.

FUNCTION UTL_RAW.CAST_FROM_BINARY_INTEGER (n IN BINARY_INTEGER, endianess IN PLS_INTEGER DEFAULT BIG_ENDIAN) RETURN RAW;

Returns the raw binary representation of n. endianess is either BIG_ENDIAN or LITTLE_ENDIAN. New with Oracle9i.

FUNCTION UTL_RAW.CAST_FROM_NUMBER (n IN BINARY_INTEGER, include_length IN BOOLEAN) RETURN RAW;

Returns the raw binary representation of n. If not include_length, the return is variable length with a maximum length of 21 bytes. New with Oracle9i.

FUNCTION UTL_RAW.CAST_TO_BINARY_INTEGER (r IN RAW, endianess IN PLS_INTEGER DEFAULT BIG_ENDIAN) RETURN BINARY_INTEGER;

Returns the binary representation of r. endianess is either BIG_ENDIAN or LITTLE_ENDIAN. New with Oracle9i.

FUNCTION UTL_RAW.CAST_TO_NUMBER (r IN RAW, include_length IN BOOLEAN) RETURN RAW;

Returns the binary representation of r. If not include_length, the return is variable length with a maximum length of 21 bytes plus the length byte, which is the first byte of the return. New with Oracle9i.

FUNCTION UTL_RAW.CAST_TO_RAW (c IN VARCHAR2) RETURN RAW;

Returns ...