Toad World® Forums

Automation of an INSERT statement


#1

Hello

I am trying to automate an INSERT statement (using Oracle DB, if it matters). I get no errors while executing the automation script but statement is not executed.

Sample

INSERT INTO AAA.ASTM_TEST
SELECT * FROM AAA.ASTM

Any advice greatly appreciated.


#2

Update and insert statements don’t return rows so you will not see a row count but they should work. If the data is not showing up in the destination table make sure your select statement is actually pulling data and then check to see if you are having a commit issue. You may not be automatically committing the insert and need to add a ; and a commit; to your sql.


#3

It worked! Thank you so much!