That would work. Mike On Wed, Sep 9, 2009 at 9:59 PM, JJ <[email protected]> wrote:
> > 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 [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
