Did you try doing something like: update user_records_table set company= (select company from the_other_table where .....[may be user_records_table.name =the_other_table .name] ...)
2009/9/9 JJ <sa...@temporaryinbox.com> > > Hi all, > > I have a list of user records that I need to update once to solve a > problem with the application that uses the table. > > The records in this table have two fields: name and company. > > I need to update the company field with the existing company name (the > name that is already in it) in order to get it to appear in the > application using the DB. > > Some of these have the company set to COMPANY X, others to COMPANY Y. > > The question I needed to ask is how can I accomplish updating the > records once with the same company that they already have? > > For example, would below SQL code work: > update user_records_table > set company=company > > Or would I have to use variables to loop through the list of records > in some manner? > > Thanks in advance > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
