OraFAQ Forum: Client Tools » Update Statement

Home » Other » Client Tools » Update Statement

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Update Statement [message #284145]

Thu, 29 November 2007 00:47

yogeshyl
Messages: 50
Registered: October 2007
Location: Silvassa

Member

How could i use 5 or more update statements in a single sql query. I want to execute the query in toad8.5. What will be the separator?

Report message to a moderator

Re: Update Statement [message #284146 is a reply to message #284145]

Thu, 29 November 2007 00:51

Michel Cadot
Messages: 68749
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

How is this a "Networking and Gateways" question?
Isn't it a "SQL Client Tools" one? -> moved

Regards
Michel

[Updated on: Thu, 29 November 2007 00:51]

Report message to a moderator

Re: Update Statement [message #284168 is a reply to message #284146]

Thu, 29 November 2007 01:34

yogeshyl
Messages: 50
Registered: October 2007
Location: Silvassa

Member

Sorry I was actually new to this forum.

Report message to a moderator

Re: Update Statement [message #284197 is a reply to message #284145]

Thu, 29 November 2007 02:51

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

Quote:

What will be the separator?

A. semi-colons
But this will not be a single sql statement. It will be 5 sql statements separated by semi-colons( Wink

Report message to a moderator

Re: Update Statement [message #284201 is a reply to message #284145]

Thu, 29 November 2007 02:56

rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India

Senior Member

What do you want to update ? Different fields in the same table Or different tables ?

If Different fields in the same table you could do in same query almost . Other wise need to executes as 5 statments. In that case seperator will be ';' as suggested by 'Pablolee'

Thumbs Up

Rajuvan.

Report message to a moderator

Re: Update Statement [message #284207 is a reply to message #284201]

Thu, 29 November 2007 03:03

yogeshyl
Messages: 50
Registered: October 2007
Location: Silvassa

Member

ok,Thanks.

Report message to a moderator

Re: Update Statement [message #284209 is a reply to message #284197]

Thu, 29 November 2007 03:06

yogeshyl
Messages: 50
Registered: October 2007
Location: Silvassa

Member

Can i execute all the update statements separated by semicolon at a same time?

Report message to a moderator

Re: Update Statement [message #284223 is a reply to message #284145]

Thu, 29 November 2007 03:29

rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India

Senior Member

Yes... you can as in Attachment. You need to execute Run to cursor option as in attchment or from debug menu.

. /forum/fa/3494/0/

Rajuvan

Attachment: Multiple_updates.jpg
(Size: 97.35KB, Downloaded 2171 times)

Report message to a moderator

Re: Update Statement [message #284226 is a reply to message #284145]

Thu, 29 November 2007 03:33

kir_ait
Messages: 198
Registered: November 2007
Location: Bangalore,India

Senior Member

Or select all statements and press F5.

Kiran.

Report message to a moderator

Re: Update Statement [message #284232 is a reply to message #284226]

Thu, 29 November 2007 03:41

yogeshyl
Messages: 50
Registered: October 2007
Location: Silvassa

Member

Thanks Kiran. By pressing F5, i also come to know the line numbers on which my statements are wrong or if any syntax problems.

As i am very new to sql as well as oracle, i don't know such little things.

Report message to a moderator

Re: Update Statement [message #284233 is a reply to message #284223]

Thu, 29 November 2007 03:43

yogeshyl
Messages: 50
Registered: October 2007
Location: Silvassa

Member

Thanks Rajuvan.

Report message to a moderator

Re: Update Statement [message #284234 is a reply to message #284145]

Thu, 29 November 2007 03:45

kir_ait
Messages: 198
Registered: November 2007
Location: Bangalore,India

Senior Member

See, this nothing to do with SQL. It is toad feature. Thats all. You can read Toad Help manual for this by pressing F1. You can also know more short cuts there.

Cheers,
Kiran.

[Updated on: Thu, 29 November 2007 03:46]

Report message to a moderator

Re: Update Statement [message #284450 is a reply to message #284232]

Thu, 29 November 2007 13:15

Frank
Messages: 7901
Registered: March 2000

Senior Member

yogeshyl wrote on Thu, 29 November 2007 10:41

If you are so new to Oracle, maybe you should focus on more important stuff than how to execute multiple statements with a single keystroke.
For starters, try to work with sqlplus instead of TOAD. GUI-tools are great and can improve productivity a great deal, but they hide so much from you that it takes away a big part of the things you need to really get an understanding of how (developing in) Oracle works.

Report message to a moderator

Previous Topic:	oracle log in problem while log ing in second time
Next Topic:	problem with toad, ORA-04043, ORA-12638

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 12 03:52:27 CDT 2025