PL/SQL Packages UTL_RAW

SQL functions for manipulating RAW datatypes.

Functions:

CAST_FROM_BINARY_INTEGER Function 
           Returns the binary representation of a BINARY_INTEGER (in RAW). 

CAST_FROM_NUMBER Function 
           Returns the binary representation of a NUMBER (in RAW). 

CAST_TO_BINARY_INTEGER Function 
           Casts the binary representation of a BINARY_INTEGER (in RAW) into a BINARY_INTEGER  

CAST_TO_NUMBER Function 
           Casts the binary representation of a NUMBER (in RAW) into a NUMBER. If include_length is TRUE, the first byte of r encodes the number of bytes in r ( 

CAST_TO_RAW Function 
           Converts a VARCHAR2 represented using n data bytes into a RAW with n data bytes. 

CAST_TO_VARCHAR2 Function 
           Converts a RAW represented using n data bytes into VARCHAR2 with n data bytes. 

CONCAT Function 
           Concatenates up to 12 RAWs into a single RAW. 

LENGTH Function 
           Returns the length in bytes of a RAW r. 

SUBSTR Function 
           Returns len bytes, starting at pos from RAW r. 

TRANSLATE Function 
           Translates the bytes in the input RAW r according to the bytes in the translation RAWs from_set and to_set. 

TRANSLITERATE Function 
           Converts the bytes in the input RAW r according to the bytes in the transliteration RAWs from_set and to_set. 

OVERLAY Function 
           Overlays the specified portion of target RAW with overlay RAW, starting from byte position pos of target and proceding for len bytes. 

COPIES Function 
           Returns n copies of r concatenated together. 

XRANGE Function 
           Returns a RAW containing all valid 1-byte encodings in succession, beginning with the value start_byte and ending with the value end_byte. 

REVERSE Function 
           Reverses a byte sequence in RAW r from end to end. 

COMPARE Function 
           Compares RAW r1 against RAW r2. 

CONVERT Function 
           Converts RAW r from character set from_charset to character set to_charset and returns the resulting RAW. 

BIT_AND Function 
           Performs bitwise logical and of the values in RAW r1 with RAW r2 and returns the anded result RAW. 

BIT_OR Function 
           Performs bitwise logical or of the values in RAW r1 with RAW r2 and returns the or'd result RAW. 

BIT_XOR Function 
           Performs bitwise logical exclusive or of the values in RAW r1 with RAW r2 and returns the xor'd result RAW. 

BIT_COMPLEMENT Function 
           Performs bitwise logical complement of the values in RAW r and returns the complement'ed result RAW.
 

For full documentation of the packaged procedures above see the Oracle Manual:
"Oracle9i Supplied PL/SQL Packages and Types Reference"

or the book Oracle Built in Packages by Steven Feuerstein et al

Related:

Application info can be pushed into V$SESSION/V$SESSION_LONGOPS



 
Copyright © 1999-2024 SS64.com
Some rights reserved