Home » SQL & PL/SQL » SQL & PL/SQL » Update data in database (oracle database 11g)
Update data in database [message #588505] Wed, 26 June 2013 05:10 Go to next message
mahnazzz
Messages: 89
Registered: July 2011
Location: Iran
Member
Hi.
I want to replace a word with another word in all tables data with varchar2 datatype that I have in my database .Is there a solution to update data at once
instead of update all column data Separately.
Re: Update data in database [message #588506 is a reply to message #588505] Wed, 26 June 2013 05:11 Go to previous messageGo to next message
Littlefoot
Messages: 18826
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As far as I can tell, it should be possible with dynamic SQL.
Re: Update data in database [message #588509 is a reply to message #588505] Wed, 26 June 2013 05:16 Go to previous messageGo to next message
Michel Cadot
Messages: 57611
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
.Is there a solution to update data at once


It depends on what you mean by "at once".

Regards
Michel
Re: Update data in database [message #588606 is a reply to message #588509] Wed, 26 June 2013 22:02 Go to previous messageGo to next message
mahnazzz
Messages: 89
Registered: July 2011
Location: Iran
Member
"at once": for example export /update/import database .
Re: Update data in database [message #588607 is a reply to message #588606] Wed, 26 June 2013 22:12 Go to previous messageGo to next message
BlackSwan
Messages: 21944
Registered: January 2009
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

You can not modify data between export & import.
Re: Update data in database [message #588610 is a reply to message #588606] Thu, 27 June 2013 00:16 Go to previous messageGo to next message
Michel Cadot
Messages: 57611
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can create a procedure which makes many updates but you call it once, is this "at once"?

Regards
Michel
Re: Update data in database [message #588636 is a reply to message #588610] Thu, 27 June 2013 04:21 Go to previous messageGo to next message
gazzag
Messages: 267
Registered: November 2010
Location: Bristol, UK
Senior Member
Could you give an example of what you're trying to achieve?
Re: Update data in database [message #588665 is a reply to message #588636] Thu, 27 June 2013 05:26 Go to previous messageGo to next message
Michel Cadot
Messages: 57611
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Update <any table> set <any column> = 'new value'
where <any table contains a column containing 'old value'

Regards
Michel

Re: Update data in database [message #588851 is a reply to message #588665] Fri, 28 June 2013 21:45 Go to previous message
mahnazzz
Messages: 89
Registered: July 2011
Location: Iran
Member
thank you
Previous Topic: Query issue (2 Merged)
Next Topic: GROUP BY
Goto Forum:
  


Current Time: Fri Apr 18 21:13:47 CDT 2014

Total time taken to generate the page: 0.08168 seconds