Re: Inserting binary data to an column

Micha wrote:
> Hi,
> i want to make a proof of concept about handling "binary data".
> Background:
> I want to get a binary decription (or hex etc) of a data stored in an
> column. Later i want to insert this binary/hex etc data directly in a column
> (by code in plsql).
> If i can make this, imable to insert any data intependent from its data
> type.
>
> Questions:
> 1. How can i get the right data representation (binary/hex etc for later
> insert)?
> 2. What are the correct statements to insert this data representation?
>
> For example:
> the hex representation of 'Technical Writer' is
> '546563686e6963616c20577269746572'
>
> so i want to get the hex number and later i want to insert it (and the
> database (i my case Oracle 10g) understand it as 'Technical Writer'
>
> Greets
>
> Micha

http://www.psoug.org/reference/convert_func.html#chtr
http://www.psoug.org/reference/dbms_xdbutil_int.html#xinh
http://www.psoug.org/reference/convert_func.html#crth
http://www.psoug.org/reference/utl_raw.html#urctr
http://www.psoug.org/reference/builtin_functions.html
http://www.psoug.org/reference/dbms_reputil.html#rurv

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org