Q:

How to get specific byte value from raw in PL/SQL?

As title says, assuming the data type of column is raw(16), is it possible to extract specific byte (for example, 5th byte) in PL\SQL? Thanks. 

A:

You can use the url_raw.substr function
   utl_raw.substr( your_column,
                   5,
                   1 )

will return a raw which contains the 1 byte that was at byte position 5 of the value passed in.

