![]() ![]() I have one machine where Toad Data Point 4.0 crashes when I start it with the error. I was thinking I could do something like this, but it doesn't like the # signs in the SQL.Īny of you automation experts run into something like this before or have any ideas? Please ask for clarification if it doesn't make sense. I have a list of all the tables and I want to loop through the list and replace the table name in the sql each time with the name from the current row in the list. I've been able to write an automation to do it for one table, but I'd have to change it each time I run it for a different table name. I just want to select all the rows from table1 in database A and insert into table1 in database B. I have many tables on one database and I want to copy the data from them to another database. ![]() ![]() Is it possible to use a variable value in SQL as part of an automation? I've seen examples where I can use a variable value in the WHERE clause to filter values selected. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |