Update multiple rows

Ok, I'm still pretty wet behind the ears in relation to Oracle, so I'm going to need a bit of leading by the nose.

I've created an associate array of data values using PHP that I need to write into an update statement for a table. Call it table A. I could make approximately 1,000+ calls (my array is 1042 results) to a single row update statement, but that strikes me as wildly inefficient. Is there a better way to do this? Can one long SQL statement be written that will accomplish the same thing?

Like I said, you'll have to talk slowly to me and use lots of pictures. I'm freshly baptised in Oracle and PL/SQL. Thanks in advance. Received on Fri Mar 26 2004 - 15:34:44 CST