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 -~----------~----~----~----~------~----~------~--~---
