To update values in a table, use the UPDATE statement.
Suppose you want to update values in the table APPLICATIONS when the STATUS column has a value of DOWN. To change the status to UP for these rows, issue this command:
OPSQL UPDATE APPLICATIONS SET STATUS = 'UP' WHERE STATUS = 'DOWN'
Copyright © 2014 CA.
All rights reserved.
|
|