Binary type in Sybase and Raw type in Oracle
Posted on 2004-10-06
I am wondering if the use of these two types are the same in Sybase 12.x and Oracle 10g
Say sybase would work if we do
insert into aSybaseTable (binaryType) values(0x80abcd)
but if we do that in oracle for a raw type say
insert into anOracleTable(rawType) values(80abcd; (or replace 80abcd with 0x80abcd)
then oracle complains: incosistent data type: expected BINARY got NUMBER
I guess what I am looking for is
1) what is the equivalent type of Sybase binary type in Oracle?
2) How would we insert a value into Oracle raw field?