Toad World® Forums

Do Multiple Update statement

Message from: Desper

I want to update a field for many records from an Excel Spreadsheet. The number
of recs is >1000 and a once off thing. I thought to generate these update
statements in the spread sheet and paste multiple Update commands into Toad.
Toad doesn’t seem to recognize any end of statement syntax. Is it possible to
run multiple update commands in TOAD or am I going about this the worng way
altogether. Thanks!


Historical Messages

Author: William
Date: Tue Jan 03 23:54:52 PST 2012
I want to update a field for many records from an Excel Spreadsheet. The number
of recs is >1000 and a once off thing. I thought to generate these update
statements in the spread sheet and paste multiple Update commands into Toad.
Toad doesn’t seem to recognize any end of statement syntax. Is it possible to
run multiple update commands in TOAD or am I going about this the worng way
altogether. Thanks!
__


Morning William,

On 04/01/12 07:54, William wrote:

I want to update a field for many records from an Excel Spreadsheet. The
number of recs is >1000 and a once off thing. I thought to generate
these update statements in the spread sheet and paste multiple Update
commands into Toad. Toad doesn’t seem to recognize any end of statement
syntax.

What “end of statement” syntax are you having difficulties with? What
errors are being raised?

Is it possible to run multiple update commands in TOAD or am I
going about this the worng way altogether. Thanks!

It depends. If you paste multiple statements, separated by a semi-colon,
into Toad and press F5 to “execute as script” it should work fine. That
feature has been around for a long long time in Toad and works.

HTH


Cheers,
Norm. [TeamT]

William,

For things like this I usually just create a temp table in Oracle and
suck in the data from the Excel spread sheet and use that temp table to
do the update. I’m not an excel wizard so this always seems the easiest
route to take when all the data is in Oracle.

Ed
[TeamT]

On 1/4/2012 4:11 AM, Norman Dunbar wrote:

Morning William,

On 04/01/12 07:54, William wrote:

I want to update a field for many records from an Excel Spreadsheet. The
number of recs is>1000 and a once off thing. I thought to generate
these update statements in the spread sheet and paste multiple Update
commands into Toad. Toad doesn’t seem to recognize any end of statement
syntax.

What “end of statement” syntax are you having difficulties with? What
errors are being raised?

Is it possible to run multiple update commands in TOAD or am I
going about this the worng way altogether. Thanks!

It depends. If you paste multiple statements, separated by a semi-colon,
into Toad and press F5 to “execute as script” it should work fine. That
feature has been around for a long long time in Toad and works.

HTH