Hi,

1. I have two questions... I want to create a binary field with the data type long raw. When I insert, I am expecting to see a 32-bit binary field displayed. This is what I am doing:

create table fac
(fac_id long raw);

insert into fac (fac_id)
values('AAAAAAAA');

... But an "A" is displayed instead. I realize that A is an hex. Does anyone know how to insert hex to raw into long raw datatypes?

2. I have three tables.. the first one with values on a field that I want on the next two tables. Can anyone share a PL/SQL that updates the next two table with the value from the first table.

Thanks