It sounded to me like he has only one table. I don't know how updating the company name with the value that is already there would solve his application problem, I'm just trusting his word on that. Mike
On Thu, Sep 10, 2009 at 7:07 AM, Javier Montani <jmont...@gmail.com> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
