Easy Oracle Question

Hello...

I am trying to move data from one table to another table. The tables have very similar designs. I will only be moving one row at a time. How do I do this? My original idea was to retrieve each column value, stick it into a temporary variable then insert the values into the target table. However, this method is not working. Please note that I need to move multiple columns worth of data.

Thank you!

A simple method is to:

INSERT INTO table
AS (SELECT column1, column2
FROM table2
WHERE column1 = 'X');

if (as in your question) you need to process each record in turn you will need to create an anonomous block (or other progam unit) eg:

DECLARE
CURSOR csr_test IS
SELECT column1, column2
FROM table;
BEGIN
FOR csr_rec IN csr_test LOOP
--additional pre-insert validation here
INSERT INTO table
VALUES
(csr_rec.column1, csr_rec.column2);
END LOOP;
COMMIT;
END;

hope this helps.