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?
Why doesn't the Oracle optimizer use my index?
Querying too much data
Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table.
So, the obvious side…
Working with Network Access Control Lists in Oracle 11g (part 1)
Part 2: http://www.e-e.com/A_9074.html
So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…