If I can latch onto Scott's question, does anyone know if a 'batch insert' is possible in Oracle (using the LV Database Connectivity Toolkit)? I want to insert up to 200 records (or as many as I can!) with a single "execution". I've been able to achieve one with MSDE, but not Oracle.
Thanks for any help. Becca MacMaster ----- Original Message ----- From: "Scott Serlin" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, January 09, 2004 2:50 PM Subject: FW: Oracle database question Can anyone tell me if it is possible to treat an Oracle database like a giant array? More to the point, do I have to always write a complete record (or row) of data into a table or is there a way to place a piece of data into one single column within the row and come back later and place a different piece of data in the same row but different column? Example: I wrote the first piece of data like this: Table testtime testdate dut serialnum productline 12:00 Later on I wanted to add another data point in the same row but different column while still maintaining the data previously entered: Table testtime testdate dut serialnum productline Can I do this? Is it allowed in Oracle? 12:00 100100 Once the row is complete, I would move onto the next row. Table testtime testdate dut serialnum productline 12:00 010603 1 100100 widget 1:00 010603 2 100101 widget
