I don't think you should be playing with this
and having fun when you could use the valuable
Christmas period for rebuilding all your indexes.
But since it's Oracle 9.2 that gets mentioned
how about trying the new bit functions:
select sys_op_rawtonum(
sys_op_vecxor(
sys_op_numtoraw(6),
LOL!
Just to add my 2c worthI think you can get a
simpler XOR implementation with:
CREATE OR replace FUNCTION bitor( x IN NUMBER, y IN
NUMBER ) RETURN NUMBER AS
BEGIN
RETURN x + y - bitand(x,y);
END;
/
CREATE OR replace FUNCTION bitxor( x IN NUMBER, y IN
NUMBER ) RETURN NUMBER AS
BEGIN
Dear All,
Jesper from the Copenhagen Business School got this crazy idea some
weeks ago, and with input from Michael MÃller of Miracle A/S, it's my
proud honor to present the World's first Oracle-based RAID-F Simulator.
It's all fun and games, of course, and Jesper got inspired after reading
Jame