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. <NB Joke>
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), sys_op_numtoraw(5) ) ) from dual / I won't guarantee that they're faster, and they certainly look messier than the pl/sql function calls, but I think they are SQL built-ins, and therefore may be faster running than pl/sql function calls. sys_op_vecor and sys_op_vecand are also available. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html ____UK___November The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, December 22, 2003 11:34 AM LOL! Just to add my 2c worth....I 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 RETURN bitor(x,y) - bitand(x,y); END; / Cheers Connor --- Jared Still <[EMAIL PROTECTED]> wrote: > 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 > James Morle's book. He simply copied the 20 pages or > so about RAID and > handed it to his boss and said that this was the > knowledge he needed to > understand the way Jesper was thinking about RAID! > The boss did read it, > and did understand it, and then Jesper went ahead > with the RFS project > just for fun. > > With the kind permission of Jared, I have attached > it. So this is your > Christmas gift from Jesper :-). > > Best regards, > > Mogens > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
