Yes, but what's the point of doing: update user_records_table set company=company ?? If you are doing an update is because you need to modify something. JJ, can you post an example of what you need?
2009/9/10 Michael Moore <michaeljmo...@gmail.com> > 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 -~----------~----~----~----~------~----~------~--~---
